Hi Expert,
I am trying to pass CREATE TABLE statement and INSERT statement on same table in PL/SQL block. Below is the code. How can I do it ?
BEGIN
EXECUTE IMMEDIATE
'CREATE TABLE BRANCH_MSTR
(
BRANCH_NO VARCHAR2(10),
NAME VARCHAR2(25)
)';
INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B1', 'VILE PARLE (HO)');
INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B2', 'ANDHERI');
COMMIT;
END;