Answer / ashutosh

you can use 3 different collections for it...

suppose the table is emp have the following columns
1. empname varchar
2. empid number
3. sal number

declare
type name_typ is table of emp.empname%type;
type id_typ is table of emp.empid%type;
type sal_typ is table of emp.sal%type;
name_tab name_typ;
id_tab id_typ;
sal_tab sal_typ;
begin
name_tab := name_typ('ramit','rohan');
id_tab := id_typ(10,20);
sal_tab := sal_typ(21000,22000);
for all i in name_tab.first .. name_tab.last
insert into emp values(name_tab(i),id_tab(i),sal_tab(i));
end;

Answer / amarnath

in stead of above discription we need to use dynamic sql.

What is an ndf file?

0 Answers  

---

What is a sql instance vs database?

0 Answers  

---

How to use transactions efficiently : transact sql

0 Answers  

---

What is meant by truncate in sql?

0 Answers  

---

Define sql delete statement.

0 Answers  

---

What is the best sql course?

0 Answers  

---

Can one improve the performance of sql*loader? : aql loader

0 Answers  

---

What do you mean by dbms? What are its different types?

0 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

0 Answers  

---

What is sql data?

0 Answers  

---

How do I view a sql database?

0 Answers  

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---