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
Amount in Words - Conversion in single SQL statement - Only in Oracle
2
if-else condition in pl/sql
bcom
HELLO WORLD
check if concatinated string obtained after reversing s1 and s2 both is a palindrome or not
Prova Supero
version_test
Cursor Employee Table. [Table create, insert and display]
Sum of n numbers