Collections:
Use "IN OUT" Parameters in Oracle
How To Use "IN OUT" Parameter Properly in Oracle?
✍: FYIcenter.com
Here are the rules about IN OUT parameters:
Here is good example of a procedure with IN OUT parameters:
SQL> CREATE OR REPLACE PROCEDURE SWAP_TEST AS 2 A NUMBER := 3; 3 B NUMBER := 8; 4 PROCEDURE MY_SWAP(X IN OUT NUMBER,Y IN OUT NUMBER) AS 5 T NUMBER; 6 BEGIN 7 T := X; 8 X := Y; 9 Y := T; 10 END MY_SWAP; 11 BEGIN 12 MY_SWAP(A,B); 13 DBMS_OUTPUT.PUT_LINE('A = ' || TO_CHAR(A)); 14 DBMS_OUTPUT.PUT_LINE('B = ' || TO_CHAR(B)); 15 END; 16 / SQL> EXECUTE SWAP_TEST; A = 8 B = 3
⇒ Define Default Values for Formal Parameters in Oracle
⇐ Use "OUT" Parameters in Oracle
2018-10-19, 2363🔥, 0💬
Popular Posts:
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......