hemant kumar
How we can create a table through procedure ?
1 Answer(s)      4 years and 9 months ago
Posted in : SQL

How we can create a table through procedure ?

Advertisement
View Answers

November 19, 2010 at 5:19 PM


Hi,

we can create table with procedure by using 'EXECUTE IMMEDIATE' command.

EXECUTE IMMEDIATE
'CREATE TABLE ' || 'EMP_' || loc ||
'(
empid NUMBER(4) NOT NULL
ename VARCHAR2(10)
empjob VARCHAR2(9)
empsal NUMBER(7 2)
empdeptno NUMBER(2)
)';

Thanks,










Related Tutorials/Questions & Answers: