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.

Which are the most commonly used sql joins?

1 Answers  

---

How do you optimize a query?

0 Answers  

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

Is big data nosql?

0 Answers  

---

Why do we use subquery?

0 Answers  

---

define sql delete statement ? : Sql dba

0 Answers  

---

Its possible to add more than one primary key for the table

4 Answers  

---

What is the maximum database size for sql express?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

Is sqlite good enough for production?

0 Answers  

---

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

22 Answers   TCS,

---