how to create table with in the procedure or function?
- 2 Answers
- 14021 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
what is uncommittable transactions? : Transact sql
How do rank () and dense_rank () differ?
How can I make sql query run faster?
What is spool?
How much ram can sql express use?
What are inner outer left and right joins in sql?
what are all the common sql function? : Sql dba
How many joins in sql?
What is sql exception?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Why stored procedure is faster than query?
what is self-join? : Sql dba
Why use triggers in sql?
Write a sql query to convert all character to uppercase after hypen.
What is a relationship and what are they?
