Identity Column: Custom name for sequence instead of system-generated name
Can an identity column be defined with a custom name instead of relying on the system-generated name? If I use an Identity column and then use Oracle Forms to determine master-detail relationships it grabs the system generated name for the sequence that gets created behind the scenes. This makes the form only useful in that database. Porting it to another database would require changing the name referenced in the master-detail relationship.
Being able to assign a name to the sequence would allow me to re-use the form in other database instances without having to edit this.
Please advise