Assign Sequence Names

MS-Access Auto Number functionality is implemented using Oracle sequences and triggers.   

 

Sequence Name:

The sequence name defaults to the Oracle table name and suffix of _SQ. The Oracle table name may optionally be assigned a prefix. The prefix and suffix are optional.

 

Sequence Trigger:

The sequence trigger defaults to the Oracle table name and suffix of _ST. The Oracle table name may optionally be assigned a prefix. The prefix and suffix are optional.