Re: "pretty Oracle SQL" utility

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 12 May 2003 15:57:26 -0700
Message-ID: <3EC026D6.CDAF87EE@exxesolutions.com>

Joel Garry wrote:

> Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EBFBC34.EA7B026E_at_exxesolutions.com>...
> > Big30 wrote:
> >
> > > Check out Formatter Plus from Quest www.quest.com. The tool is included
> > > with TOAD and SQL Navigator.
> > >
> > > HTH
> > >
> > > "Ramkumar Krishnan" <Ramkumar.Krishnan_at_oracle.com> wrote in message
> > > news:3EBBD3FD.9020605_at_oracle.com...
> > > > Could you pls point me to an utility that
> > > > returns "prettied" SQL given an arbitrary
> > > > SQL input (Oracle8i SQL and above would be
> > > > great, but if absent, Oraclev7 is fine for
> > > > starts). Found this:
> > > > www.pickledbeans.com/scripts/Perl/prettysql.txt
> > > > from Google, but I got a 404 Error during
> > > > access.
> > > >
> > > > Thank you for your time and response.
> > > >
> > > > Regds, Ram
> > > >
> >
> > Norman alluded to it. I can live with it being on the market though I still
> > would prefer a world where such tools didn't exist and developers learned
> > their trade.

>

> I honestly don't understand this. I see things all the time like two
> programmers will format their code similarly, yet by using different
> editors the code doesn't compare correctly with the unix diff command.
> I don't see where a tool that eliminates such problems has much to do
> with developers learning their trade. In fact, I've seen such tools
> help rapidly integrate the new person into a group, since often
> different places have different styles. The best is to get everyone
> to contribute to an agreed set of standards at the beginning, but the
> reality is people come and go and any manual process is going to have
> variance.

>

> I was going to direct the OP to one of the lint-like tools out there,
> but couldn't find one in less than 30 seconds.

>

> jg
> --
> @home.com is bogus. Hey, let's all go in on some Oracle oriented
> screen-destroyers for our users:
> http://www.cheapinvitations.com/storefront/Save_The_Date_Magnets.htm
> (disclaimer: Yes, I'm related to some of the people on that site.)

The problem is one of appearance over substance. I am a firm believer in formatted code. Have been since I first put keyboard to disk. That said formatters encourage sloppy practices with an expectation that the tool will solve the problem. Good code requires structured thinking and the tool can't produce that.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon May 12 2003 - 17:57:26 CDT