Skip to Main Content

SQL & PL/SQL

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 do you format your Oracle code ?

ManikNov 27 2017 — edited Dec 1 2017

Hi all,

Just going back to basics.

We all know that formatting the code is an integral and important aspect of coding any programming language.. I just wanted to learn how do you format your Oracle code?

What are the different points to remember while formatting. Especially when we see code snippets from (sorry to take names, but just an attempt to gather info) Frank / Billy /SY  etc.., they have unique styles , any tool used for that? If so please share,  I always use TOAD/(sometimes SQLDeveloper) for formatting, but not as elegant as Frank's one (for e.g.)

I definitely agree that manual formatting is a "proper" way of formatting, but manual formatting is definitely an overhead and you need tons of patience to sit and manually adjust snippets for simple spacing etc... especially when you can get the job done via some third party tool.

Share your thoughts please.

Cheers,

Manik.

"No shortcuts for success"

This post has been answered by Billy Verreynne on Nov 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2017
Added on Nov 27 2017
61 comments
4,054 views