Sequences

CDP provides the following sequences:

• ING_AUTHORIZED_USER_SEQ: Used to generate the primary keys for the ING_AUTHORIZED_USER table.

• ING_COLUMN_DEFAULT_SEQ: Used to generate the primary keys for the ING_COLUMN_DEFAULT table.

• ING_ENCRYPTED_COLUMN_SEQ: Used to generate the primary keys for the ING_ENCRYPTED_COLUMN table.

• ING_ENCRYPTED_TABLE_SEQ: Used to generate the primary keys for the ING_ENCRYPTED_TABLE table.

• ING_ERROR_LOG_SEQ: Used to generate the primary keys for the ING_ERROR_LOG table.

• ING_JOB_SEQ: Used to generate the primary keys for the ING_JOB table.

To view sequence data, execute the following command: select <sequence_name.[nextval|currval]> from dual;

Examples

SQL> SELECT ING_COLUMN_DEFAULT_SEQ.NEXTVAL FROM DUAL;
Output:
NEXTVAL
----------
1
SQL> SELECT ING_COLUMN_DEFAULT_SEQ.CURRVAL FROM DUAL;
Output:
CURRVAL
----------
1