Using Beautifier with Column Alias

DISCADMIN

Member
I am currently using version 5.1.4.730.

When I use the beautifier option on my SQL, any column alias I have defined end up right next to the column again. I need my sql to be pretty so if I can go from this:
T.ATTRIBUTE4 ITEM_4,
T.ATTRIBUTE5 ITEM_5,
to this:
T.ATTRIBUTE4 ITEM_4,
T.ATTRIBUTE5 ITEM_5,

that would be a great help! When there is a long list of items with column alias, it makes viewing the file much easier and more friendly if the alias are all lined up nice and pretty.

I have searched and made every modification to the beautifier I know and still have had 0% success. :confused:

Is there an option that will currently align alias or will this be an enhancement request?
 
your before/after example look exactly alike to me. Maybe you should use a '.' for a space so we can see what you mean.
 
Sorry about that. After formatting, I would want to look something like this (where . is replaced with a space). So no matter how long the item is, the alias is always aligned.

T.ATTRIBUTE4.................ITEM_4,
T.ATTRIBUTE5.................ITEM_5,
T.CUSTOMER_ADDRESS...........ADDRESS
 
Actually like this:

T.ATTRIBUTE4.................ITEM_4,
T.ATTRIBUTE5.................ITEM_5,
T.CUSTOMER_ADDRESS.....ADDRESS
 
If you enable the "Align" option of the Select statement on the DML tab page of the PL/SQL Beautifier Options, the alignment will be as follows:
Code:
SELECT T.ATTRIBUTE4       ITEM_4,
       T.ATTRIBUTE5       ITEM_5,
       T.CUSTOMER_ADDRESS ADDRESS
  FROM SOME_TABLE
 
I've done this and they do not align correctly. I use the tab as follows:
SELECT T.ATTRIBUTE4ITEM_4,
T.ATTRIBUTE5ITEM_5,
T.CUSTOMER_ADDRESSADDRESS
FROM SOME_TABLE
 
I type in select t.attribute4 press the tab button type in my alias and add a comma then press the enter key and start the next line.
 
Back
Top