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 an escape character in sql?

1009

---

What is localdb mssqllocaldb?

1053

---

Is it possible to pass parameters to triggers?

1086

---

How do I view a sql database?

1007

---

what is not null constraint? : Sql dba

1007

---

How to get list of all tables from a database?

1139

---

How do I view a view in sql?

937

---

What is posting?

1026

---

how to drop an existing view in mysql? : Sql dba

1043

---

What is a dynamic query?

1009

---

What is a memo field?

946

---

What is sap sql?

960

---

What are sql functions? Describe in brief different types of sql functions?

1077

---

What view means?

963

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

939

---