Updating an oracle sequence nextval

The sequence’s last value is stored in memory and a certain definable number of values are pre-fetched and cached in memory (default is CACHE=20). The resulting SQL_ID and statement for this recursive SQL is: In our case it was the #1 top statement in terms of cumulative CPU.

Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).

The typical use case for this context with regards to default generation is to have access to the other values being inserted or updated on the row.

To access the context, provide a function that accepts a single member is a special member provided only during the execution of a default function for the purposes of deriving defaults from its existing values.

By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.

NEXTVAL, 'FORD', : ENABLED_USER_ID); INSERT INTO USERS (ID, USR_NAME) VALUES (: DISABLED_USER_ID, 'ANDREW'); INSERT INTO CAR (CAR_ID, CAR_NAME, USR_ID) VALUES (CARSEQ.

945

Leave a Reply