Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
ff
--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 select banner as "oracle version" from v$version DECLARE v_counter BINARY_INTEGER := 1; v_sum NUMBER := 0; BEGIN WHILE v_counter <= 10 LOOP v_sum := v_sum + v_counter; DBMS_OUTPUT.PUT_LINE ('Current sum is: '||v_sum); -- increment counter v_counter := v_counter + 1; END LOOP; DBMS_OUTPUT.PUT_LINE ('The sum of integers between 1 ' || 'and 10 is: '||v_sum); END;
run
|
edit
|
history
|
help
0
Reverse of a number
minimum of two(replace)
Example of Local and Global variables
prime number programe using pl/sql
Srinivas
Understanding while loop
bcom
create table
Srinivas
DECODE() example