Friday 12 July 2013

Can we create a table using with Procedure or Function?

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

DECLARE
BEGIN
EXECUTE IMMEDIATE 'create table employee(empno number(3) ename varchar2(10))';
END;

No comments:

Post a Comment