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, 1626🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...