Answer Posted / 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;

How do I know if I have sql express or standard?

1039

---

Does oracle use sql?

936

---

Explain what is a subquery ?

1193

---

What is record in pl sql?

1090

---

Is grant a ddl statement?

904

---

What is identity column in sql server?

1054

---

Why stored procedure is faster than query?

1068

---

Mention what does plv msg allows you to do?

1127

---

how to show all tables with 'mysql'? : Sql dba

1121

---

What is the location of pre_defined_functions.

1167

---

what is rdbms? : Sql dba

1018

---

What is server name sql?

1153

---

Can we alter stored procedure?

994

---

What is sql and db2?

1013

---

Inline the values in PL/SQL, what does it mean.?

1234

---