Key Column Sequence Name

The collection metadata component that specifies the name of the database sequence that generates keys for documents that are inserted into a collection if the key assignment method is SEQUENCE.

If you specify the key assignment method as SEQUENCE then you must also specify the name of that sequence. If the specified sequence does not exist then SODA creates it.

Property	Value
Default value	None
Allowed values	Valid Oracle quoted identifier1 (as defined in Oracle Database SQL Language Reference). If this value contains double quotation marks (") or control characters, SODA replaces them with underscore characters (_).
JSON collection metadata document path	keyColumn.sequenceName

Note: If you drop a collection using SODA, the sequence used for key generation is not dropped. This is because it might not have been created using SODA. To drop the sequence, use SQL command DROP SEQUENCE, after first dropping the collection.

See Also:

• Oracle Database SQL Language Reference for information about DROP SEQUENCE
• Oracle Database Concepts for information about database sequences

Related Topics

• Key Column Assignment Method

1. Reminder: letter case is significant for a quoted SQL identifier; it is interpreted case-sensitively. ↩