Jean-Paul Finne
Member²
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.
I don't want to buy a license of Quest Formatter Plus.
standalone beautifier
- Thread starter Jean-Paul Finne
- Start date
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 =(
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).
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.
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.
The PL/SQL Beautifier (as the name suggests) only beautifies PL/SQL. It does not know DDL commands.
Huh?
Stew Stryker
Member³
I'm guessing aqua is dreaming that the Beautifier will some day support DDL commands too.
Lord knows I'd like to see that support added.
Lord knows I'd like to see that support added.
Damn right...
Honestly, for the last few weeks I've tested tens of differenet formatters. It is very sensitive question for our project. My feelings now can be described as a some sort of panic: THERE IS NO 100% WORKING SQL/PLSQL FORMATTER AT ALL.
The only usable thing is "tuned" old version of standalone Quest Formatter Plus, shrinked out from SQL Navigator (which is the worse tool I've ever seen), "patched" to work properly, with new version of FmtPlus.DLL provided.
I've even bought SD PL/SQL Formatter. The only thing I can say about this one - SUX. I've spend only 30 minutes to provide famous Ira Baxter (CTO of SD) with 10-15 documented test cases showing that the product is non-functional at all. She tried to answer to me for some time... At the moment it's silence from their side...
All this making me very upset........
Honestly, for the last few weeks I've tested tens of differenet formatters. It is very sensitive question for our project. My feelings now can be described as a some sort of panic: THERE IS NO 100% WORKING SQL/PLSQL FORMATTER AT ALL.
The only usable thing is "tuned" old version of standalone Quest Formatter Plus, shrinked out from SQL Navigator (which is the worse tool I've ever seen), "patched" to work properly, with new version of FmtPlus.DLL provided.
I've even bought SD PL/SQL Formatter. The only thing I can say about this one - SUX. I've spend only 30 minutes to provide famous Ira Baxter (CTO of SD) with 10-15 documented test cases showing that the product is non-functional at all. She tried to answer to me for some time... At the moment it's silence from their side...
All this making me very upset........
Stew Stryker
Member³
aqua,
Yes it's nice to have code formatted the way you'd like to read it but would your team's productivity increase that much if you could format DML and DDL exactly the way you wanted?
I've been known to spend way too much time playing with the formatting style in FormatterPlus (back when we used SQL/Nav, the bad old days!). However, it's still hard for me to see it considered "sensitive" for a project. But that's probably just because I'm not in your shoes.
Assuming you're good with Developer's beautifier functionality for DML, have you considered having a team member write a Developer plugin to add the DDL support? I'd be willing to beta-test it for you and look over your shoulder and make stupid suggestions!
Best of luck,
I'm not trying to be rude but that sounds like slightly mismatched priorities to me.
Yes it's nice to have code formatted the way you'd like to read it but would your team's productivity increase that much if you could format DML and DDL exactly the way you wanted?
I've been known to spend way too much time playing with the formatting style in FormatterPlus (back when we used SQL/Nav, the bad old days!). However, it's still hard for me to see it considered "sensitive" for a project. But that's probably just because I'm not in your shoes.
Assuming you're good with Developer's beautifier functionality for DML, have you considered having a team member write a Developer plugin to add the DDL support? I'd be willing to beta-test it for you and look over your shoulder and make stupid suggestions!
Best of luck,
