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;

which types of join is used in sql widely? : Sql dba

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

What is the difference between sql/pl-sql/embeded sql?

3 Answers  

---

What are aggregate functions in sql?

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

Can we insert in sql function?

0 Answers  

---

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

---

What is input buffer in sql*plus?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---