Re: Eclipse for SQL development in place of Toad
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Tue, 16 Apr 2013 14:24:48 +0200
Message-ID: <516D4310.5060300_at_mgm-tp.com>
Lukas Lehner, 16.04.2013 14:17:
> On Tue, Apr 16, 2013 at 9:53 AM, Thomas Kellerer <thomas.kellerer_at_mgm-tp.com <mailto:thomas.kellerer_at_mgm-tp.com>> wrote:
>
> If your primary task is running SQL (rather than programming and debugging PL/SQL)
> you might want to have a look at SQL Workbench/J:
>
> http://www.sql-workbench.net
>
> does it has a Code Beautifier And Formatter feature?
Date: Tue, 16 Apr 2013 14:24:48 +0200
Message-ID: <516D4310.5060300_at_mgm-tp.com>
Lukas Lehner, 16.04.2013 14:17:
> On Tue, Apr 16, 2013 at 9:53 AM, Thomas Kellerer <thomas.kellerer_at_mgm-tp.com <mailto:thomas.kellerer_at_mgm-tp.com>> wrote:
>
> If your primary task is running SQL (rather than programming and debugging PL/SQL)
> you might want to have a look at SQL Workbench/J:
>
> http://www.sql-workbench.net
>
> does it has a Code Beautifier And Formatter feature?
It does have a SQL Formatter. Although the more complex the SQL statements get, the less reliable it works (because the formatter is not doing a complete logical parsing of the statements). And - being a DBMS independent tool - it will not recognize all possible Oracle specific constructs either.
If by "Code Beautifier" you mean a formatter for PL/SQL programs, then the answer to that is no.
Regards
Thomas
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 16 2013 - 14:24:48 CEST