how to create table with in the procedure or function?

Question Posted / rameshrevella

2 Answers
13616 Views
Genpact, HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to create table with in the procedure or function?..

Answer / 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

how to create table with in the procedure or function?..

Answer / 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