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 can sql server reporting services do?

1055

---

Can we change the table name in sql?

888

---

How many types of cursors are available in pl/sql?

1042

---

Does asenumerable execute the query?

983

---

What is field delimiter?

989

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1114

---

Advantages and disadvantages of stored procedure?

1058

---

What is difference between rank () row_number () and dense_rank () in sql?

1049

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

---

What is clustered and nonclustered index in sql?

894

---

Why do you partition data?

966

---

Why commit is not used in triggers?

992

---

What is a delimiter in sas?

979

---

What is clustered index in sql?

1001

---

Can we use having without group by in sql?

927

---