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;

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

what is the difference between join and union? : Sql dba

0 Answers  

---

How many joins can you have in sql?

0 Answers  

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

What is graph sql?

0 Answers  

---

What programs use sql?

0 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Explain raise_application_error.

0 Answers  

---

what is variable in package specification

3 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

How do you copy a table in sql?

0 Answers  

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---