Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
PL/SQL declaracionVariables
--Oracle 11g Express Edition --please drop objects you've created at the end of the script --or check for their existance before creating --'\\' is a delimiter /* DECLARE a integer := 30; b integer := 40; c integer; f real; BEGIN c := a + b; dbms_output.put_line('Value of c: ' || c); f := 100.0/3.0; dbms_output.put_line('Value of f: ' || f); END; */ -- *************************************************************** DECLARE -- global variable 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 variable num1 number:= 195; num22 number:= 185; BEGIN dbms_output.put_line('inner variable num1: ' || num1); dbms_output.put_line('inner variable num1: ' || num2); dbms_output.put_line('inner variable num1: ' || num22); END; END;
run
|
edit
|
history
|
help
0
DBMS
scott
Регулярное выражение, ограничить количество
sum of array in pl/sql
Srinivas
HELLO WORLD
Cursor Explicit
oracle plan
Kartik DBMS Program
college