Oracle cursor for updating every row in same table high school dating games

Oracle cursor for updating every row in same table

' records.' ); 39 40 DBMS_OUTPUT. ERROR_INDEX

49 SQL%BULK_EXCEPTIONS(i).

oracle cursor for updating every row in same table-88oracle cursor for updating every row in same table-5oracle cursor for updating every row in same table-67

Using record-based PL/SQL we can now BULK COLLECT into one associative array and FORALL INSERT the entire record into a target table without ever having to reference either a column from the staging or target tables or an attribute from a record element in the associative array. DECLARE 2 3 TYPE typ_aa_allobj IS TABLE OF all_objects%ROWTYPE 4 INDEX BY PLS_INTEGER; 5 aa_allobjs typ_aa_allobj; 6 7 BEGIN 8 9 SELECT * BULK COLLECT INTO aa_allobjs 10 FROM all_objects; 11 12 FORALL i IN aa_allobjs. PUT_LINE ( 17 TO_CHAR(SQL%ROWCOUNT) || 18 ' records inserted.' ); 19 20 END; 21 / Obviously this type of operation would usually be best implemented via SQL as an INSERT..

Join our conversation (74 Comments).
Click Here To Leave Your Comment Oracle cursor for updating every row in same table.

Comments:

Leave a Reply

Your email address will not be published. Required fields are marked *