how to create table with in the procedure or function?
- 2 Answers
- 14019 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 are the benefits of pl sql?
How is sql used in oracle?
Does inner join remove duplicates?
Can we create table inside stored procedure?
What is use of package in pl sql?
What is the meaning of disabling a trigger?
What type of database is sql?
What is the difference between execution of triggers and stored procedures?
Enlist some predefined exceptions?
When is a declare statement required?
What are keys in sql?
What is the difference between the implicit and explicit cursors?
What is the difference between inner join and natural join?
What is the process of debugging?
How do you rank data in sql?
