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 is trigger and types?

965

---

What is nested table in pl sql?

1004

---

how to start mysql server? : Sql dba

1142

---

What is the use of index in sql?

958

---

What is the use of stored procedures?

975

---

Define sql delete statement.

953

---

What are the two types of cursors in pl sql?

1001

---

What is a data definition language?

1027

---

What are its different types of dbms?

955

---

How many sql databases can you have on one server?

1016

---

What is exception? What are the types of exceptions?

1030

---

what is a record in a database ? : Sql dba

995

---

Does pl sql work in mysql?

919

---

What is mutating sql table?

1038

---

what is the difference between nested subquery and correlated subquery?

986

---