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, 1444🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...