How we can create a table through procedure ?

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,