OraFAQ Forum: Suggestions & Feedback » Announcement: Online SQL and PL/SQL Formatter

Home » Other » Suggestions & Feedback » Announcement: Online SQL and PL/SQL Formatter (

) 2 Votes

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

Announcement: Online SQL and PL/SQL Formatter [message #127162]

Sat, 09 July 2005 07:30

Frank Naude
Messages: 4590
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

Report message to a moderator

Re: Announcement: Online SQL and PL/SQL Formatter [message #127194 is a reply to message #127162]

Sat, 09 July 2005 15:33

Barbara Boehmer
Messages: 9104
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/

Report message to a moderator

Re: Announcement: Online SQL and PL/SQL Formatter [message #127201 is a reply to message #127194]

Sat, 09 July 2005 17:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Neat feature, it might reduce the number of unreadable posts that circle the forum.

MHE

Report message to a moderator

Re: Announcement: Online SQL and PL/SQL Formatter [message #136341 is a reply to message #127194]

Wed, 07 September 2005 11:36

Frank Naude
Messages: 4590
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

Report message to a moderator

Re: Announcement: Online SQL and PL/SQL Formatter [message #136371 is a reply to message #136341]

Wed, 07 September 2005 15:03

Barbara Boehmer
Messages: 9104
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"?

Report message to a moderator

Re: Announcement: Online SQL and PL/SQL Formatter [message #136572 is a reply to message #136371]

Thu, 08 September 2005 15:45

Frank Naude
Messages: 4590
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 11:49:22 CST 2025