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.

Can we insert delete data in view?

0 Answers  

---

Which sorts rows in sql?

0 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---

what is global table

7 Answers   iFlex,

---

What is the use of partition by in sql?

0 Answers  

---

What is the difference between microsoft sql and mysql?

0 Answers  

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

What is clustered index in sql?

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---