SQL_INITIALIZE_SEQUENCE¶
Applies to: ORAFlex PGFlex
This command is used to initialize all auto increment columns, or sequences in Oracle, of the specified table to be the highest number plus one. This is useful when inserting a large amount of records in the table and the sequence is not being updated because the auto incremented column is being manually filled.
Syntax
SQL_INITIALIZE_SEQUENCE of {FILE.File_Number}
Parameter |
Description |
---|---|
FileNumber |
The file number |