PL-SQL Beautifier Rules enhancement request

Felix

Member²
I have two request:

1. Exclusion function list for Item List:
Under the General Tab in the Item Lists, I like to use One item per line for most procedure/function calls, but I would like to have an exclusion list of functions not to beautify. Either leave it alone or try to fit as much in one line (up to the margin). In this exclusion list I would put functions, such as SUBSTR, NVL, TRANSLATE, REPLACE, etc., since they do not look good.

For example:

Before Beautifier I had the following in one line:
IF SUBSTR(p_fac_link_rec.side_z.location,1,8) != SUBSTR(p_ckt_order.ckt_fac_location_z,1,8) THEN

After Beautifier:
IF SUBSTR(p_fac_link_rec.side_z.location,
1,
8) != SUBSTR(p_ckt_order.ckt_fac_location_z,
1,
8) THEN

2. items alignment options for ORDER BY or GROUP BY on the SELECT DML:
 
Forum Post lost formating. The 1 and 8 are aligned below the (. Re-posted using . for spaces:

IF SUBSTR(p_fac_link_rec.side_z.location,
.............1,
.............8) != SUBSTR(p_ckt_order.ckt_fac_location_z,
..............................1,
..............................8) THEN
 
Last edited:
Hi.

Is it possible to add the ability to align equal signed in WHERE clause of DML statements like you do in SET of UPDATE statement, seems it's not a big deal, maybe even something like copy-and-paste of most of the code.

Thanks, it'll be really cool!
 
Back
Top