Format views...

[birdwellconsulting]

Hello,

This is my first post to this forum and I appologize if the answer is posted one the site and I missed it.

I am looking for a beautifier option or other plug-in to format Oracle Apps views similiar to how it is done in Toad. I am using 5.2 of the developer.

Thanks in advance,
Tad Stephens
tad@birdwellconsulting.com

 

[Marco Kalter]

To format a view, you must select the select statement, and invoke the PL/SQL Beautifier. It cannot format DDL commands, but it can format a select statement within a DDL command.