Is it possible to use pl/sql developper to format pl/sql code from the command line ?

I don't want to buy a license of Quest Formatter Plus.

This is on the list of enhancement requests (you're not the first to ask).

Hi!

I see you've thought about this feature since 2004 or may earlier. What's going on in this direction? Are you still planning to provide us with this feature?

My company is your customer and we've just faced with the problem that no command-line formatting utility is available on the market (at least good enough utility =)). That's sad =(

The "beautify" and "set beautifierrules" commands have been added to the Command Window to support this (see chapter 7.3 in the User's Guide). This allows you to run a script that beautifies multiple objects from the Command Window, or from the Windows Command Prompt (by using the commandfile=[script] parameter).

I was talking about pure command-line utility that can be used as a part of any command-line based process such as build, cvs submission etc.

This is possible. For example:

plsqldev.exe userid=scott/tiger commandfile=beautify_all.pdc

In the beatify_all.pdc script you can end with an EXIT APPLICATION command to terminat PL/SQL Developer after running all beautify operations.

OK... Honestly, it looks fuzzy... and funny =] But ok.

But what about DDL formatting?

How is it possible to format DDL statements such as CREATE TABLE?

The PL/SQL Beautifier (as the name suggests) only beautifies PL/SQL. It does not know DDL commands.

Expected?

Huh?