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;

What is the difference between subquery and correlated query?

1065

---

Can we insert delete data in view?

950

---

Why do we use partitions in sql?

1049

---

Does pdo prevent sql injection?

932

---

How can I delete duplicate rows?

1017

---

What does (*) mean in sql?

951

---

What is having clause in sql?

964

---

Is oracle sql free?

987

---

What is trigger in pl sql with examples?

1042

---

how would you get the current date in mysql? : Sql dba

967

---

How can you tell the difference between an index and a view?

937

---

What is the difference between a database and a relational database?

1103

---

How do you declare a variable in pl sql?

1028

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1101

---

Is big data nosql?

944

---