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
2018-10-13, 728👍, 0💬
Popular Posts:
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...