Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obey column_id order in Generate Table API?

PaavoSep 21 2016 — edited Sep 28 2016

I am using

pastedImage_0.pngin pastedImage_2.png

And when generating api with :

pastedImage_1.png

The generated api's record definition and the ins,del,upd procedures have column orders which look like random to me.

Is there way to force the api-generation to obey the column_id sort order ?

Also is there way to bypass trigger updated fields e.g. id from sequence and such - based e.g. on the field name convention?

rgrds paavo

ps. sorry if this is already asked question - didn't yet find answer to this....

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2016
Added on Sep 21 2016
14 comments
899 views