<div>
Forgot this link. <a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html" rel="ugc">http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html</a>
</div>


<div>
i dont have that one. but can you feed it a whole unformated stored procedure and it will gie you a nicely formatted code line by line?<br />
<br />
i noticed each tool will format differently sometimes and some may not be very good.
</div>


<div>
It has always worked pretty well for me. &nbsp;I am usually not putting in large pl/sql statements, but I would recommend trying it. &nbsp;
</div>


<div>
<div class="content wysiwyg-content">
I have some pl/sql code that is not formated well. lot od blank lines, no indentation, IFs not aligned, etcc...<br />
<br />
Is there any nice tools out there that will format it nicely by selecting part of or the whole procedure.<br />
<br />
The code also has lots of commented code for old logic. Is it good to leave this in ir get rid of it. Sometimes this helps to see the history of changes or going &nbsp;back to old functionality.<br />
<br />
I have TOAD and SQL NAVIGATOR and SQL*PLUS tools.
</div>
</div>


I have some pl/sql code that is not formated well. lot od blank lines, no indentation, IFs not aligned, etcc...

Is there any nice tools out there that will format it nicely by selecting part of or the whole procedure.

The code also has lots of commented code for old logic. Is it good to leave this in ir get rid of it. Sometimes this helps to see the history of changes or going  back to old functionality.

I have TOAD and SQL NAVIGATOR and SQL*PLUS tools.

Forgot this link. http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

i dont have that one. but can you feed it a whole unformated stored procedure and it will gie you a nicely formatted code line by line?

i noticed each tool will format differently sometimes and some may not be very good.

It has always worked pretty well for me.  I am usually not putting in large pl/sql statements, but I would recommend trying it.  

plsqlCodeForrmatterTool

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Development in most programming languages is frequently done with an editor or integrated development environment (IDE). An IDE is a software application that provide comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, build automation tools and a debugger. XCode, Visual Studio, Adobe Dreamweaver and Eclipse are some of the more popular development tools, but an editor or IDE can be anything from simple text editors to sophisticated programs. Related topics: All programming and development language, database and web based content management systems topics