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 the order of pre-defined exceptions.

6 Answers   TCS,

---

Does group by remove duplicates?

0 Answers  

---

how to create user in sql and how to set password for that?

3 Answers  

---

What is the purpose of normalization?

0 Answers  

---

How to write html code in pl sql?

0 Answers  

---

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

display null value rows with out using null function?

8 Answers   Infosys,

---

How to fetch alternate records from a table?

0 Answers  

---

how to sort records in sql?

3 Answers  

---