8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Using the TABLE Operator with Locally Defined Types in PL/SQL

Anil said...

Is ForAll better or table operator now for updates?

Tim... said...


You can't update against a table function. Perhaps you mean INSERT INTO ... SELECT, in which case you could use this for the SELECT, for use an INSERT in a FORALL. They both have different pros and cons, so there is not a "better" one. It depends.



Tim Thompson said...

Just noticed a complication that took an hour or so to figure out:

If one of the columns in the rowtype is a float then casting the array to a table will work, but you will be unable to reference the columns in it. To solve this create a record of the same structure but substituted a number for the float and use the record type to define the associative array rather than a row type.


DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!