create table using procedure create procedure test as begin EXECUTE I

how to create table with in the procedure or function?

Question Posted / k.l.tharangini

2 Answers
14644 Views
Genpact, HCL, I also Faced
E-Mail Answers

Answer Posted / k.l.tharangini

create table using procedure

create procedure test as
begin
EXECUTE IMMEDIATE
'CREATE TABLE emp(empno VARCHAR(10),JOB VARCHAR(10),SAL
NUMBER(10))';
end;

Is This Answer Correct ?

43 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does oracle roll back the transaction on an error?

1000

Are there any features that are decommissioned in 11g that are not present in 11g?

2125

What type of database is cloud sql?

1084

How to run pl/sql statements in sql*plus?

1060

What is difference sql and mysql?

966

What is nosql vs sql?

1157

how do you know if your mysql server is alive? : Sql dba

1063

Why do we need pl sql?

956

How do I pipe the output of one isql to another?

990

What is application trigger?

977

What are the parts of a sql statement?

1072

what are the different type of sql's statements ? : Sql dba

904

Which software is used for pl sql programming?

970

What is difference between group by and partition by?

1040

What is the purpose of a sql?

962