SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create a dynamic Table using procedure

User_KKLFRAug 6 2021

create or replace procedure Pro_Tbl_Cre( P_TBL_NAME IN VARCHAR2)
is
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE '||P_TBL_NAME||' (Empname VARCHAR2(100), EmpId Number)';
End;
I'm facing error. How to write it properly?

Added on Aug 6 2021

#11g, #oracle, #pl-sql, #plsql, #query

4 comments

3,548 views

1 mention