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 can I get the number of records affected by a stored procedure?

1118

What is union and union all keyword in sql and what are their differences?

1152

Explain the structure of pl/sql in brief.

1135

How many row comparison operators are used while working with a subquery?

1069

Is ms sql is free?

1077

How can you select unique records from a table?

1144

Why partition by is used in sql?

1080

What makes a good primary key?

1093

How does postgresql compare to "nosql"?

1077

What is a unique key and primary key and foreign key?

1020

What do you understand by case manipulation functions?

1074

Can we update views in sql?

985

What is the difference between function and procedure in pl/sql?

1134

what is the difference between myisam static and myisam dynamic? : Sql dba

1111

What is natural join in sql?

1042