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 sql a case sensitive language?

932

How much ram can sql express use?

979

How insert into statements in sql?

1066

How exception handling is done in advance pl/sql?

978

what are all the common sql function? : Sql dba

1056

What is schema in sql?

941

What is a ddl command?

1080

What is record data type?

908

What is trigger and how to use it in sql?

1020

Explain architecture of sql server notification services?

1054

What is the difference between functions, procedures, and packages in pl/sql?

1040

What are all the different types of indexes?

1145

Which tcp/ip port does sql server run?

995

how to concatenate two character strings? : Sql dba

1091

how to convert numeric values to character strings? : Sql dba

1099