Collections:
Scope of Local Variables in Oracle
What Is the Scope of a Local Variable in Oracle?
✍: FYIcenter.com
The scope of a variable can be described with these rules:
Here is a sample script to show you those rules:
SQL> CREATE OR REPLACE PROCEDURE PARENT AS 2 X CHAR(10) := 'FYI'; 3 Y NUMBER := 999999.00; 4 PROCEDURE CHILD AS 5 Y CHAR(10) := 'CENTER'; 6 Z NUMBER := -1; 7 BEGIN 8 DBMS_OUTPUT.PUT_LINE('X = ' || X); -- X from PARENT 9 DBMS_OUTPUT.PUT_LINE('Y = ' || Y); -- Y from CHILD 10 DBMS_OUTPUT.PUT_LINE('Z = ' || TO_CHAR(Z)); 11 END; 12 BEGIN 13 DBMS_OUTPUT.PUT_LINE('X = ' || X); -- X from PARENT 14 DBMS_OUTPUT.PUT_LINE('Y = ' || TO_CHAR(Y)); 15 -- DBMS_OUTPUT.PUT_LINE('Z = ' || TO_CHAR(Z)); 16 CHILD; 17 END; 18 / SQL> EXECUTE PARENT; X = FYI Y = 999999 X = FYI Y = CENTER Z = -1
⇒ Working with Database Objects in Oracle PL/SQL
⇐ What Are Named Parameters in Oracle
2018-10-13, 1453🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...