Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Oracle java
--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 * from empx --select * from all_tables where table_name like '%MY_TIME_%' CREATE OR REPLACE Procedure UpdateCourse () IS BEGIN FOR c IN (SELECT EMPNO,ENAME,SAL FROM empx) LOOP execute immediate 'Create table MY_TIME_'|| EMPNO ||' AS Select X.* FROM Metadata X'; END LOOP; END;
run
|
edit
|
history
|
help
1
fff
by Srimathi Mannarsamy, 2 years ago
Please
log in
to post a comment.
BCOM
Srinivas
Srinivas
4
Srinivas
Sum of n numbers
jxs1
add pl/sql
temporal overlap in oracle
bcom
fff
by Srimathi Mannarsamy, 2 years agoPlease log in to post a comment.