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

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

956

What is java sql package?

1090

Why truncate is used in sql?

1003

how to get @@error and @@rowcount at the same time? : Sql dba

1026

How to call a javascript function from pl sql?

1138

What is write ahead logging in sql server?

1048

Which one is better subquery or joins?

1060

Why cross join is used?

1074

What is oracle sql developer?

1047

What language is oracle sql developer?

1010

What is the need of merge statement?

1038

When do we use triggers?

1078

Explain autonomous transaction.

1154

What is pl/sql table? Why it is used?

1036

what is 'trigger' in sql? : Sql dba

1084