Answer / kishore

Sure,we can write bulk collect in triggers also.
Bulk Collect purpose is just to retrieve the multivalues of
attribute into a collection(like array,record,tables etc)

What is record data type?

0 Answers  

---

What is trigger types of trigger?

0 Answers  

---

What is sql catalog?

0 Answers  

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

Is sql developer case sensitive?

0 Answers  

---

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

What do you mean by “trigger” in sql?

0 Answers  

---

What is compilation error in pl sql?

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---