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!

How to Disable Formatting of PL/SQL

Joseph UpshawDec 14 2021 — edited Dec 14 2021

SQL Developer Data Modeller Version 21.2.0.183 Build 183.1957
We'd like to keep our procedures, functions, triggers, etc. in the model itself. This makes it very convenient when we want to be sure we have a complete set of scripts needed to implement a model. However, the changes that SQL Developer Data Modeller automatically makes to the code when the DDL is generated make it harder to read and, really, just add nothing of value for us.
This is only an issue in the generated DDL. We can open the definition and our code looks as it was originally entered. For example, when we edit a function, our original formatting is still there. However, when we generate the DDL, it gets changed to something way less readable and, moreover, it gets implemented in the database with this awkward formatting.
Is there any way to simply turn off this auto-formatting? When we create the objects, we have it just the way we like it. Can we just have it kept the way that we entered it when the DDL is generated?
Thanks,
-Joe

Comments
Post Details
Added on Dec 14 2021
2 comments
713 views