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;

What is cursor in pl sql with examples?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

What are local and global Indexes and where they are useful.

0 Answers  

---

What does “select count(1) from tab” result?

10 Answers   IBM,

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

How can I tell if sql is running?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

What is a primary key example?

0 Answers  

---

What type of join is sql join?

0 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

What is the purpose of normalization?

0 Answers  

---