Yes We can write a create command in a PL/SQL block using dynamic SQL

Can we write create command in the plsql block?if possible
how?

Question Posted / sidh

Answer Posted / sidh

Yes We can write a create command in a PL/SQL block using
dynamic SQL

eg Execute immediate 'create table tab_name....'

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to select all records from the table?

1117

what are the advantages a stored procedure? : Sql dba

962

What does where 1 1 mean in sql?

1019

How delete a row in sql?

974

What are the benefits of triggers?

1160

What is the difference between clustered and non-clustered indexes?

1074

which tcp/ip port does sql server run on? : Sql dba

1006

What is restrict in sql?

1093

What is pl sql code?

1035

How many disk partitions should I have?

975

What is a .db file?

961

What packages are available to pl/sql developers?

1030

How do I remove all records from a table?

1062

Why we use pl sql?

942

What is set serveroutput on?

1120