Collections:
Use "OUT" Parameters in Oracle
How To Use "OUT" Parameter Properly in Oracle?
✍: FYIcenter.com
Here are the rules about OUT parameters:
Here is good example of a procedure with an OUT parameter:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(40) := 'FYICenter.com'; 3 MESSAGE CHAR(80); 4 PROCEDURE WELCOME_PRINT(S IN CHAR, M OUT CHAR) AS 5 BEGIN 6 M := 'Welcome to ' || S; 7 END; 8 BEGIN 9 WELCOME_PRINT('MySpace.com', MESSAGE); 10 DBMS_OUTPUT.PUT_LINE(MESSAGE); 11 WELCOME_PRINT(SITE, MESSAGE); 12 DBMS_OUTPUT.PUT_LINE(MESSAGE); 13 END; 14 / SQL> EXECUTE WELCOME; Welcome to MySpace.com Welcome to FYICenter.com
⇒ Use "IN OUT" Parameters in Oracle
⇐ Use "IN" Parameters in Oracle
2018-10-19, 1779🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...