Database Administration (MOSC)

MOSC Banner

Identity Column: Custom name for sequence instead of system-generated name

edited Sep 8, 2020 5:09AM in Database Administration (MOSC) 6 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center