Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Create a dynamic table
CREATE OR REPLACE PROCEDURE createdynamictable IS BEGIN FOR n IN 1 .. 100 LOOP dbms_output.put_line('1'); execute immediate 'DROP TABLE Persons_'||n; execute immediate 'CREATE TABLE Persons_'||n||'(PersonID NUMBER(3) PRIMARY KEY,Name varchar(20),Address varchar(20),City varchar(20))'; execute immediate 'INSERT INTO Persons_'||n||' (PersonID,Name,Address,City) VALUES (1,'''''Rahul'''',''''Marine Drive''''','''''Mumbai''''')'; END LOOP; END createdynamictable; SELECT * FROM dba_tables\\ INSERT INTO Persons_1 (PersonID,Name,Address,City) VALUES (1,'Rahul','Marine Drive','Mumbai')\\ SELECT * FROM Persons_1\\
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
To find out first day of month without trunc function
display student details in pl/sql
addition of arrays
PL/SQL declaracionVariables
write a programe of simpleInterest
HELLO WORLD
5
cote corr
Understanding basic loop
Factorial from SQL
stackse - search stackoverflow differently
Please log in to post a comment.