Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Example of Local and Global variables
DECLARE -- Global variables num1 number := 95; num2 number := 85; BEGIN dbms_output.put_line('Outer Variable num1: ' || num1); dbms_output.put_line('Outer Variable num2: ' || num2); DECLARE -- Local variables num1 number := 195; num22 number := 185; BEGIN dbms_output.put_line('Inner Variable num1: ' || num1); dbms_output.put_line('Inner Variable num2: ' || num2); dbms_output.put_line('Inner Variable num2: ' || num22); END; END;
run
|
edit
|
history
|
help
0
even and odd plsql block
prime number programe using pl/sql
HELLO WORLD
Srinivas
0607-3
test out
Understanding basic loop
ttt
scott
DBMS