declare v_ddl_stat varchar2(200):='create table '||'&ta

How to call DDL statements from pl/sql?

Question Posted / santosh kumar

5 Answers
33458 Views
I also Faced
E-Mail Answers

Answer Posted / santosh kumar

declare
v_ddl_stat varchar2(200):='create table '||'&table_name'||'
('||'&column_names'||')'; --col_name like(eid number(5),name
varchar2(10))
begin
EXECUTE IMMEDIATE v_ddl_stat;
END;
/

Is This Answer Correct ?

8 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I order columns in sql?

914

How do you update sql?

915

What is nvarchar max in sql?

960

What is nosql db?

926

Are sql database names case sensitive?

937

How do I truncate a word?

1002

What does <> sql mean?

989

Is postgresql a server?

997

What is Histogram?

1506

Where is all the data on the internet stored?

949

What is gpt format?

894

What are the types of views in sql?

1041

Is left join inner or outer?

964

What are the types of queries in sql?

1016

Is sql better than access?

965