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

What is the reports view in oracle sql developer?

536

what is recursive stored procedure? : Sql dba

524

Is not equal in sql?

562

What is meant by temporal data?

538

What are the operators in sql?

522

What does select * from mean in sql?

1984

What is execute immediate?

547

How do I make sql search faster?

552

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1636

What is data type in sql?

554

What does count (*) do in sql?

519

describe transaction-safe table types in mysql : sql dba

501

What are actual parameters and formal parameters?

565

What does truncate mean in sql?

533

Can we call procedure in select statement?

516