Oracle sql updating multiple rows

Suppose there is such a list - let's call it likes - that records the number of likes for the objects that can be liked in a website.

The id is an incremental primary key without business meaning.

The gmt_xxx contains the record creation and update time without business meaning.

oracle sql updating multiple rows-86oracle sql updating multiple rows-46

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='

70

Leave a Reply