Feature request for PL/SQL Beautifier

[stevec]

Could handling SQL script be added to the list of enhancements for the Beautifier please
- I appreciate you can select the PL/SQL in the SQL script, but it's a bit of a pain

 

[Marco Kalter]

Do you mean a SQL script in the Command Window, with multiple SQL statements, PL/SQL Blocks, and SQL*Plus commands?

------------------
Marco Kalter
Allround Automations

 

[stevec]

Yeap Marco, I've got mixed SQL, SQL*Plus + PL/SQL scripts
- if I try the Beautifier and there are none-PL/SQL lines at the beginning of the script, I get the warning "PL/SQL Beautifier could not parse text"
- however it works if there are none-PL/SQL lines at the end of the script ??

 

[stevec]

Another point, on WHERE clauses with AND's in, is there any way to format the AND's ??
e.g. current output
WHERE dpcase.caseno = dphrqcmp.caseno AND dpcase.dpclass3 = 'NEW' AND
dpcase.dpclass4 = 'GREEN';

would like
WHERE dpcase.caseno = dphrqcmp.caseno
AND dpcase.dpclass3 = 'NEW'
AND dpcase.dpclass4 = 'GREEN';

or even
WHERE dpcase.caseno = dphrqcmp.caseno
AND dpcase.dpclass3 = 'NEW'
AND dpcase.dpclass4 = 'GREEN';

 

[stevec]

Blast the html stripped out the leading spaces on the second example

so . are
WHERE dpcase.caseno = dphrqcmp.caseno
...AND dpcase.dpclass3 = 'NEW'
...AND dpcase.dpclass4 = 'GREEN';

 

[Marco Kalter]

I have added your first request to the list of enhancement requests.

Additional formatting control for conditions is on our to-do list.

------------------
Marco Kalter
Allround Automations

 

[stevec]

Thanks again Marco

 

[roselan]

I was gonna ask for the "AND on new line" stuff. Si I will ask for 3 nice to have (personal) points

"first parameter on new line":
P_Procedure (
Pi_First_parameter T_type ,
Pi_Second_parameter T_type )
as
V_Variable ...

"space before/after symbol":
x:=(a+b)/c*100| |'%';
would then become:
x := ( a + b ) / c * 100 | | '%' ;

"Align = signs"
select *
from a_table
where fisrt_fld = P1
and second_fld = p2;

damn, UBB is not the best sql editor I know

 

[Marco Kalter]

Use:

(your formatted code here)
[/ code] (no space between / and code)

------------------
Marco Kalter
Allround Automations