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;

Is not null in sql?

0 Answers  

---

how will you find out the last three records in a table with n no of records and delete them

3 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

What are the different datatypes available in PL/SQL?

0 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

what is a unique key ? : Sql dba

0 Answers  

---

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

---

What are predefined functions in sql?

0 Answers  

---

How do you select unique values in sql?

0 Answers  

---

How to Execute a Package in PL/SQL.?

0 Answers   MCN Solutions,

---

What is the current version of postgresql?

0 Answers  

---

Do prepared statements prevent sql injection?

0 Answers  

---