Answer Posted / prabhudatta barick

#"The keywords BULK COLLECT tell the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine.
#You can use these keywords in the SELECT INTO, FETCH INTO, and RETURNING INTO clauses. Here is the syntax:

... BULK COLLECT INTO collection_name[, collection_name] ..."

#"The keyword FORALL instructs the PL/SQL engine to bulk-bind input collections before sending them to the SQL engine.
Although the FORALL statement contains an iteration scheme, it is not a FOR loop. Its syntax follows:

FORALL index IN lower_bound..upper_bound
sql_statement;

The index can be referenced only within the FORALL statement and only as a collection subscript.
The SQL statement must be an INSERT, UPDATE, or DELETE statement that references collection elements. And, the bounds must specify a valid range of consecutive index numbers.
The SQL engine executes the SQL statement once for each index number in the range."

Can we rename a column in the output of sql query?

995

---

What are the three pl sql block types?

1009

---

Is keyword pl sql?

1002

---

How do I find duplicates in a single column in sql?

1020

---

Explain the difference between triggers and constraints?

975

---

Does sql profiler affect performance?

994

---

Is sql a dbms?

1014

---

What are secondary keys?

971

---

What is database migration?

970

---

What is a design view?

924

---

What does sql stand for?

997

---

How do I pipe the output of one isql to another?

1006

---

How many primary keys can a table have?

1009

---

How to Declare Fixed Length String Value In PL SQL

1155

---

what is blob? : Sql dba

1149

---