Home » Other » General » Best Tool to re-formatting Oracle PL/SQL
Best Tool to re-formatting Oracle PL/SQL [message #265279] Thu, 06 September 2007 00:05 Go to next message
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
Re: Best Tool to re-formatting Oracle PL/SQL [message #265280 is a reply to message #265279] Thu, 06 September 2007 00:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

SQL*PLUS.
Re: Best Tool to re-formatting Oracle PL/SQL [message #265281 is a reply to message #265280] Thu, 06 September 2007 00:19 Go to previous messageGo to next message
Maaher
Messages: 7062
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
Re: Best Tool to re-formatting Oracle PL/SQL [message #265518 is a reply to message #265281] Thu, 06 September 2007 09:33 Go to previous messageGo to next message
Ronald Beck
Messages: 121
Registered: February 2003
Senior Member
I like using PL/SQL Developer from allroundautomations (www.allroundautomations.com).
Re: Best Tool to re-formatting Oracle PL/SQL [message #265588 is a reply to message #265518] Thu, 06 September 2007 12:15 Go to previous messageGo to next message
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
Re: Best Tool to re-formatting Oracle PL/SQL [message #265643 is a reply to message #265588] Thu, 06 September 2007 15:21 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Best Tool to re-formatting Oracle PL/SQL [message #270936 is a reply to message #265279] Fri, 28 September 2007 08:06 Go to previous message
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.
Previous Topic: Enquiry about oracle products
Next Topic: table size
Goto Forum:
  


Current Time: Sat Dec 03 22:19:38 CST 2016

Total time taken to generate the page: 0.06516 seconds