XXX Chats

Adult webcamming

Updating oracle table sequence

In Oracle, a sequence object (created by CREATE SEQUENCE statement) is used to generate IDs (auto-increment, identity values).In Oracle, you can create an auto increment field using ‘sequence’ database object that can be assigned as primary keys.Using Oracle ‘sequence’ object, you can generate new values for a column.

‘ID’; l_seq := p_tbl

Comments Updating oracle table sequence

  • How to Set Current Value of a Sequence Without Dropping.
    Reply

    Jan 21, 2011. and is based on dear Tom Kyte's answer https//asktom.oracle.com/pls/apex/f?p=10P11_QUESTION_ID1119633817597. just as FYI Wonder why Oracle doesn't just have “ALTER SEQUENCE X RESTART AT nvalue” Simple enuf for.…