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 the process of debugging?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

What is trigger explain it?

0 Answers  

---

What is data control language (dcl)?

0 Answers  

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

How to call a javascript function from pl sql?

0 Answers  

---

What are variables in pl sql?

0 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

Which command is used to delete a trigger?

0 Answers  

---

What is assignment operator in pl sql?

0 Answers  

---

is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,

---

what is single byte over head in oracle..?

0 Answers  

---