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

Is a secondary key the same as a foreign key?

1036

How can I speed up sql query?

962

Why do we use partitions in sql?

1048

How do I filter in sql profiler?

992

Is sql better than excel?

1152

what is the syntax for using sql_variant_property? : Transact sql

1040

Can we commit in trigger?

975

What are operators available in sql?

1044

What jobs use sql?

980

what are the difference between clustered and a non-clustered index? : Sql dba

1032

How do I count rows in sql query?

988

Why do we need cursors in pl sql?

1078

What is left join example?

947

what does myisamchk do? : Sql dba

1016

Write a sql query to convert all character to uppercase after hypen.

1438