how to create table with in the procedure or function?
- 2 Answers
- 13624 Views
- Genpact, HCL, I also Faced
- E-Mail Answers
Answer Posted / vipin kumar
If we need to create a table in the stored procedure then we need to use the execute immediate and then the string ' create table emp(name varcha2(1000))'
Other then this if we need to create a table which will just store the records (collections) then it will be like
--declare a row first
type employee is record
(Emp_name varchar2(100),
emp_id number);
--
-- Create a table now
--
type tab_employee is table of employee
index by binary_integer;
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
What is the most important ddl statements in sql are?
What are views in sql?
What if we write return in procedure?
What is a data definition language?
Why cross join is used?
How many sql statements are used? Define them.
what is sp_pkeys? : Transact sql
Can we join 3 tables in sql?
What is query syntax?
What is where clause in sql?
Will truncate release space?
what is a trigger in mysql? : Sql dba
Why we use joins in sql?
When is a declare statement required?
What are sql functions? Describe the different types of sql functions?
