how to create table with in the procedure or function?
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
What is the max nvarchar size?
What is data modelling in sql?
Why is sharding used?
how do you control the max size of a heap table? : Sql dba
How do I quit sql?
Does sql use python?
What are pl/sql cursors?
What are all the different normalizations?
What plvcmt and plvrb does in pl/sql?
What is the example of procedure?
What type of join is sql join?
How does rowid help in running a query faster?
What is dialect in sql?
Why do we use function in pl sql?
how many ways to get the current time? : Sql dba