Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Cursor Explicit
--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 c_id customers.id%type; c_name customers.name%type; c_addr customers.address%type; CURSOR c_customers is SELECT id, name, address FROM customers; BEGIN OPEN c_customers; LOOP FETCH c_customers into c_id, c_name, c_addr; EXIT WHEN c_customers%notfound; dbms_output.put_line(c_id || ' ' || c_name || ' ' || c_addr); END LOOP; CLOSE c_customers; END;
run
|
edit
|
history
|
help
0
alle angemeldeten Benutzer können eine gegebene aktion ausgeben ( im Web )
Prime number
Srinivas
fiddle for between
Function to return factorial of a number in PLSQL
nago
Oracle java
Patient0021
SQL for overlapping ranges
alle angemeldeten Benutzer können eine gegebene aktion ausgeben