Re: Eclipse for SQL development in place of Toad

From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Tue, 16 Apr 2013 15:27:26 +0100
Message-ID: <516D5FCE.6030308_at_dunbar-it.co.uk>



On 16/04/13 13:39, Thomas Kellerer wrote:

> I agree ;)

;-)

> The reason I added it to my own tool was when I had to look at SQL statements from (application) logfiles.
> They are usually just one long string and very hard to read. Quickly applying some basic rules (line breaks etc), helps tremendously.
Aha, that makes perfect sense. I do remember a long time ago, extracting   the SQL statements to create tables from an exp dump file because the exporting DBA thought that COMPRESS=Y just compressed the file to make it smaller. It actually added all the existing extents into one huge one!

I think that code formatting would have been extremely useful then. This was in the days before locally managed tablespaces.

Cheers,
Norm.

-- 
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 16 2013 - 16:27:26 CEST

Original text of this message