Collections:
Define Default Values for Formal Parameters in Oracle
How To Define Default Values for Formal Parameters in Oracle?
✍: FYIcenter.com
If you have an IN parameter, you can make it as an optional parameter for the calling statement by defining the formal parameter with the DEFAULT clause. This gives you the freedom of not providing the actual parameter when calling this procedure or function. See the following tutorial script shows you an example procedure with an optional parameter:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE GREETING(S IN CHAR DEFAULT 'FYICenter') AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || S); 5 END; 6 BEGIN 7 GREETING('MySpace.com'); 8 GREETING; 9 END; 10 / Procedure created. SQL> EXECUTE WELCOME; Welcome to MySpace.com Welcome to FYICenter
⇒ What Are Named Parameters in Oracle
⇐ Use "IN OUT" Parameters in Oracle
2018-10-19, 1595🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...