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;
BEGIN
EXECUTE IMMEDIATE 'create table employee(empno number(3) ename varchar2(10))';
END;
No comments:
Post a Comment