yeah the above answer is correct.. begin execute immediate 'create

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

Question Posted / umadevi

Answer Posted / umadevi

yeah the above answer is correct..

begin
execute immediate 'create table tablename(column_name
coloumn_type(coloumn_length))';
end;

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the types of variable use in pl sql?

1066

how are mysql timestamps seen to a user? : Sql dba

1133

What are user defined functions?

1006

List the various privileges that a user can grant to another user?

1036

What is normalization? How many normalization forms are there?

1080

What are some predefined exceptions in pl/sql?

1158

What is memory optimized table?

1037

List the ways to get the count of records in a table?

900

What is the advantage of index in sql?

962

What sql does db2 use?

971

What is aggregate function in sql?

1030

What is sql select statement?

1028

What is the difference between mdf and ndf files?

1112

Does sql require a server?

1002

How does index help in query performance?

1024