Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL code formatters

Re: PL/SQL code formatters

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Thu, 09 Mar 2006 09:41:04 +0200
Message-ID: <440fdc10$0$10069$ba624cd0@newsread.funet.fi>


Gerry Atric wrote:
> Looking for recommendations from people who use any of the pl/sql formatting
> utilities out there... seems to be quite a number available... I tried an
> online one and it introduced errors in the code where no errors existed
> before. One with a JDev plugin would be nice but not essential.

I have used an online SQL and PL/SQL formatter at http://www.orafaq.com/cgi-bin/sqlformat/pp/utilities/sqlformatter.tpl . Remember to select dialect (default is Access). It can format only a procedure a time, so it took some time to format a bigger package, but it was worth it.

--
Arto Viitanen, CSC Ltd.
Espoo, Finland
Received on Thu Mar 09 2006 - 01:41:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US