Updating multiple rows in oracle Punjabi sex livn chat

But since the select statement is returning multiple records, I am not able to update the value of mfg_fac.

updating multiple rows in oracle-67updating multiple rows in oracle-40

The returned data could be a single column, multiple columns or expressions.

When we insert data using a sequence to generate our primary key value, we can return the primary key value as follows.

It is taking too much of time to execute.....than 6 minutes......

DROP TABLE t1; DROP SEQUENCE t1_seq; CREATE TABLE t1 ( id NUMBER(10), description VARCHAR2(50), CONSTRAINT t1_pk PRIMARY KEY (id) ); CREATE SEQUENCE t1_seq; INSERT INTO t1 VALUES (t1_seq.nextval, 'ONE'); INSERT INTO t1 VALUES (t1_seq.nextval, 'TWO'); INSERT INTO t1 VALUES (t1_seq.nextval, 'THREE'); COMMIT; clause allows us to return column values for rows affected by DML statements.

I understand that I can do this with one row and it work with a nested select statement in an update statement.

l_id); END; / ID=4 PL/SQL procedure successfully completed.

Tags: , ,