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;

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;

How does an execution block start and end in pl sql?

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

How to raise user-defined exception with custom sqlerrm ?

0 Answers  

---

What is #table in sql?

0 Answers  

---

What is compiled query?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

What are some emotional triggers?

0 Answers  

---

What is string data type in sql?

0 Answers  

---

What pl/sql package consists of?

0 Answers  

---

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---