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.

How to recompile a already made trigger?

2 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

Is keyword pl sql?

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

Can we use delete in merge statement?

0 Answers  

---

What is the purpose of cursors in pl/sql?

0 Answers  

---

What are two statement types in sql?

0 Answers  

---

Explain what is sql?

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---