asked on

How to format PL SQL code?

Dear Experts,

i need to format PL SQL code, i.e IF and END IF should be in the same line. like this needs to format the code to improve the readability.

please provide any free tool to format the pl sql code.

slightwv (䄆 Netminder)

What have you looked at so far?

http://www.google.com/#sclient=psy-ab&hl=en&site=&source=hp&q=oracle+pl+sql+code+beautifier

sammySeltzer

why not post your code here so someone can help you format it?

Sean Stuber

SQL Developer from oracle is free and includes a formatter

a new version was just released yesterday

johnsone

I use:

http://www.dpriver.com/pp/sqlformat.htm

Does queries and PL/SQL. Just make sure you pick Oracle/PLSQL from the drop down because it is not the default.

HainKurt

look at here: http://www.dpriver.com/pp/sqlformat.htm

copy, paste, click "Format SQL"

Edit: oops, already posted :) Actually I use TOAD (commercial version) and it has tons of settings and you can customize all settings, then press Shift + Ctrl + F in editor...

BhanuSVS

ASKER

Dear sdstuber,

Please show me where is the option in sql developer to format pl sql code, and kindly share the download like to download new version of pl sql.

Swadhin Ray

Please find the download link for Oracle SQL Developer:

Latest Version : Oracle SQL Developer 3.1 (3.1.07.42)

Download Link: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Format code option follow this link:
http://st-curriculum.oracle.com/obe/db/sqldev/r21/sqldev21nf/sqldev21nf.htm#t5

ASKER CERTIFIED SOLUTION

Swadhin Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BhanuSVS

ASKER

Thanks