Bulk updating multiple columns in oracle

Bulk updating multiple columns in oracle

SQL SET SERVEROUTPUT ON DECLARE TYPE t_desc_tab IS TABLE OF t1.description%TYPE; TYPE t_tab IS TABLE OF t1%ROWTYPE; l_desc_tab t_desc_tab := t_desc_tab('FIVE', 'SIX', 'SEVEN'); l_tab t_tab; BEGIN FORALL i IN l_desc_tab.first ..

l_tab.count bulk updating multiple columns in oracle-76bulk updating multiple columns in oracle-28bulk updating multiple columns in oracle-81

SET SERVEROUTPUT ON DECLARE l_id t1.id%TYPE; BEGIN INSERT INTO t1 VALUES (t1_seq.nextval, 'FOUR') RETURNING id INTO l_id; COMMIT; DBMS_OUTPUT.put_line('ID=' || l_id); END; / ID=4 PL/SQL procedure successfully completed.

Join our conversation (43 Comments).
Click Here To Leave Your Comment Bulk updating multiple columns in oracle.

Comments:

Leave a Reply

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