how to create table with in the procedure or function?
- 2 Answers
- 13628 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
Where not exists in sql?
how do you know the version of your mysql server? : Sql dba
Why do we use function in pl sql?
what is log shipping? : Sql dba
What is the most restrictive isolation level? : Transact sql
Is sql pronounced sequel or sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are the different ways to optimize a sql query?
how can you see all indexes defined for a table? : Sql dba
Is sql a backend?
What are the dml statements?
Show how functions and procedures are called in a pl/sql block.
What are sql functions? Describe the different types of sql functions?
Why trigger is used in sql?
What is an oracle stored procedure?
