Re: Pretty Printer for PL/SQL Code

[Quoted] Surely you have some coding standards or guidelines for your project(s). In it I would expect a line that reads something like "code should be formatted using indentation to show code structure".

What you're describing is cause enough, i think, to fail the quality check/review and send the code back to the developer for changing/fixing. It shouldn't be up to the reviewer to make code readable - it should be the developer, surely.

Just my twopence worth!!!

Alan

"Stefan Meissner" <boromir_86_at_gmx.de> wrote in message news:b05pr2$8ug$1_at_pentheus.materna.de...
> Hi all,
>
> I am searching for a tool which works as an auto-formatter for PL/SQL
> code. In Borland JBuilder this feature is called 'Pretty printer' in
> emacs it is called 'indent-region'. Both indent the code after writing
> it. I have to review a lot of code written by others and often in an
> awful way so that there is no chance to understand the code because it
> looks like this:
>
> if ... then
> bla;
> bla;
> bla;
> if ... then
> bla;
> bla;
> else
> bla;
> end if;
> end if;
>
> Do you know any tool oder add-in (SQL-Navigator 4, emacs plug-in for
> PL/SQL, Textpad, Ultra-edit, ...) which supports this?
>
> Thanks in advance
> Stefan
>
Received on Thu Jan 16 2003 - 12:18:29 CET