Skip to Main Content

SQL Developer Data Modeler

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!

Alter table add column at a certain position

User_84SZKMar 10 2021

Hey,
like I can see, it is possible to generate automatically alter/rename scripts using “Data type conversion” to copy a table to another. This is described in Jeffs blog.
https://www.thatjeffsmith.com/archive/2012/03/diffs-and-alter-scripts-via-oracle-sql-developer-data-modeler/
Is there also a possibility to add columns at a certain position afterwards?
So can data modeler generate an automated script for this or exist a workaround to generate it?

This post has been answered by Philip Stoyanov-Oracle on Mar 12 2021
Jump to Answer

Comments

akira_jain

The Oracle Database 12c is a high-performance, enterprise-class database. According to Oracle, this is "the first database designed for the cloud." Oracle Database 12c also introduces 500 new features to the database, most notably pluggable databases and multitenant architecture.

Thanks For Sharing!!!

Thanks. That is Great Article.

1 - 2

Post Details

Added on Mar 10 2021
3 comments
3,063 views