Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Minimising deep indentation
> I have taken over some PL/SQL code which is deeply indented.
> Some lines have 10-12 tabs before code appears on them. I want
> to minimise this. I don't even mind introducing an
> "indent_help_exception" for this purpsoe.
I would hesitate to rewrite working code just to eliminate undesired indentation. Even then, I would rather move the heavily indented blocks to a new procedure before rewriting.
Personally, I set my text editor to make a tab stop every 2 characters instead of the default 8, which also makes this kind of code a lot easier to read.
Quest used to make a product called "Formatter Plus", which would format your PL/SQL based on a variety of rules you set up. It was pretty decent - much better than the formatting built into TOAD. However, they seem to have deprecated the product. I haven't used the newer versions of TOAD, but maybe they incorporate the more sophisticated Formatter Plus features. I don't know if anyone else has ever come up with another stand-alone "pretty printer" for PL/SQL. Received on Wed May 25 2005 - 17:01:45 CDT