OraFAQ Forum: General » Best Tool to re-formatting Oracle PL/SQL

Home » Other » General » Best Tool to re-formatting Oracle PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Best Tool to re-formatting Oracle PL/SQL [message #265279]

Thu, 06 September 2007 00:05

bagulia_pilla
Messages: 25
Registered: July 2006

Junior Member

Hi Friends,
I need to format the sql. Please give some tool where i can re-format the sql statement nicely.

I have toad.. Other than any other tool
Thanks in advance
Bagulia

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #265280 is a reply to message #265279]

Thu, 06 September 2007 00:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL*PLUS.

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #265281 is a reply to message #265280]

Thu, 06 September 2007 00:19

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Arju wrote on Thu, 06 September 2007 07:09

SQL*PLUS.

For formatting? I don't think so. The forum here has a formatter. I usually use a text editor and format manually (a text editor with column edit mode is handy). Sometimes I use TOAD's built in formatter. For the rest I'd check Google.

MHE

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #265518 is a reply to message #265281]

Thu, 06 September 2007 09:33

Ronald Beck
Messages: 121
Registered: February 2003

Senior Member

I like using PL/SQL Developer from allroundautomations (www.allroundautomations.com).

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #265588 is a reply to message #265518]

Thu, 06 September 2007 12:15

andrew again
Messages: 2577
Registered: March 2000

Senior Member

or Oracle's free SQL Developer.
http://www.oracle.com/technology/products/database/sql_developer/index.html

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #265643 is a reply to message #265588]

Thu, 06 September 2007 15:21

Littlefoot
Messages: 21782
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

When I first started to use Oracle, it was on OpenVMS and we connected to it by VT terminals (character environment). Its editor wasn't good at all (regarding formatting capabilities), so I had to manually format SQLs while typing (indenting, keywords in capital letters, ...) so - when TOAD came to my hands, I still don't like to rely on its formatting ideas (as sometimes its formatting looks worse than mine) but rather take care about it myself.

But, of course, that's not a reason for you to follow my steps.

Report message to a moderator

Re: Best Tool to re-formatting Oracle PL/SQL [message #270936 is a reply to message #265279]

Fri, 28 September 2007 08:06

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

I recently ran across an editor called OpenEditor which is really nice. It would be more along the lines of an editor that lets you manually reformat things, as opposed to a formatter that does it for you. But, it makes it much easier and faster to change indentation, caps, etc.

Report message to a moderator

Previous Topic:	Enquiry about oracle products
Next Topic:	table size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 04:19:51 CDT 2023