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;

What are the set operators in sql?

1065

---

What is difference between group by and partition by?

1053

---

How many sql commands are there?

1112

---

what is clause? : Sql dba

1056

---

What is the difference between view and stored procedure?

959

---

What is the basic structure of an sql?

1098

---

Which certification is best for sql?

981

---

How to rename a table?

1010

---

which tcp/ip port does sql server run on? : Sql dba

1018

---

How do you use a while loop in pl sql?

1003

---

What is the meaning of disabling a trigger?

1168

---

What is trigger explain with example?

1029

---

Is sql low level language?

1013

---

What is the sql case statement?

987

---

What are aggregate functions in sql?

1151

---