Answer / Anoop Kumar Srivastava

Bulk Collect in Oracle is a PL/SQL collection feature that allows you to fetch multiple rows from SQL queries into arrays for efficient data handling. It can improve performance by reducing the number of calls made between the database and the application.

Why do we use coalesce function in oracle?

1 Answers  

---

How to set a transaction to be read only in oracle?

1 Answers  

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

Explain about your project and its relation to the current job position you are applying to?

1 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1 Answers   GTL,

---

What is an Extent ?

3 Answers  

---

Please explain drop constraint oracle?

1 Answers  

---

How to create a testing table in oracle?

1 Answers  

---

what is host string in sql plus? how does it related to database?

1 Answers  

---

How can we Update a table with out using UPDATE command?

1 Answers  

---

What is the data pump import utility?

1 Answers  

---