Home » Other » Suggestions & Feedback » Announcement: Online SQL and PL/SQL Formatter  () 2 Votes
Announcement: Online SQL and PL/SQL Formatter [message #127162] Sat, 09 July 2005 07:30 Go to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
The Oracle FAQ now has a SQL and PL/SQL Formatter on-line.

Benefits:
  • Makes code easier to read and maintain
  • Properly indents code written by non-programmers
  • Standardize code when multiple developers with different coding styles work together on the same project

Try it out at http://www.orafaq.com/utilities/sqlformatter.htm

Best regards.

Frank
Re: Announcement: Online SQL and PL/SQL Formatter [message #127194 is a reply to message #127162] Sat, 09 July 2005 15:33 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Thanks for providing the nice utility. I copied and pasted a function into it, just to test it. It did not recognize the DETERMINISTIC keyword and said it was expecting AS or IS and it added an extra semicolon at the bottom of the function that did not belong there. I expect there may be a few such bugs, but it seems like a nice utility. I have used something similar here:

http://www.sqlinform.com/

Re: Announcement: Online SQL and PL/SQL Formatter [message #127201 is a reply to message #127194] Sat, 09 July 2005 17:17 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Neat feature, it might reduce the number of unreadable posts that circle the forum.

MHE
Re: Announcement: Online SQL and PL/SQL Formatter [message #136341 is a reply to message #127194] Wed, 07 September 2005 11:36 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
We've just upgraded the SQL Formatter. Some of the enhancements:

1. It now recognizes the DETERMINISTIC keyword
2. Statements can be formatted as Pro*C or Pro*COBOL code
3. More formatting options

Best regards.

Frank
Re: Announcement: Online SQL and PL/SQL Formatter [message #136371 is a reply to message #136341] Wed, 07 September 2005 15:03 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Thanks for the nice improvements. Is there any way to fully integrate it with the existing reply screen? Could you, for example, add a button for "format message", just like you have a button for "spell-check message"?
Re: Announcement: Online SQL and PL/SQL Formatter [message #136572 is a reply to message #136371] Thu, 08 September 2005 15:45 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi Barbara,

Unfortunately it would not be possible. The formatter is not open source - we cannot change the source code.

Best regards.

Frank
Previous Topic: Any Plans for RSS on the Forums?
Next Topic: Punctuation - it exists, use it!!
Goto Forum:
  


Current Time: Thu Mar 28 03:54:02 CDT 2024