Beautifier question/request

[Stian]

Hi,

I really like the beautifier in PL/SQL Developer but in DMLs I would like the comparators in WHERE clause to allign. Is there som option to do this? If not I would like there to be one.

Oracle SQL Developer is getting better all the time and it's new and improved formatter does this.

I get this today:

SELECT 'VARIABLE1'
      ,'VARIABLE123'
      ,'VARIABLE_ABC'
      ,1
      ,10
FROM   dual
WHERE  1 = 1
AND    10 = 10
AND    'VARIABLE1' = 'VARIABLE1'
AND    'VAR_2' NOT LIKE 'VAR_3%'
AND    'VAR_2x' LIKE 'VAR_2%';

but I would like something like this:

SELECT 'VARIABLE1'
      ,'VARIABLE123'
      ,'VARIABLE_ABC'
      ,1
      ,10
FROM   dual
WHERE  1              = 1
AND    10             = 10
AND    'VARIABLE1'    = 'VARIABLE1'
AND    'VAR_2' NOT LIKE 'VAR_3%'
AND    'VAR_2x'    LIKE 'VAR_2%';

Regards
Stian

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[Gustavo]

This one would really be great!

 

[William Robertson]

Not to mention the missing space after the comma. They even have it here:http://www.dpriver.com/pp/sqlformat.htm

 

[Gustavo]

Marco,

This one would also be welcome in 9.1.

Regards,
Gustavo

 

[Gustavo]

This has not been implemented yet...

 

[Michaeljohn]

comparators in WHERE clause to allign. Is there som option to do this? If not I would like there to be one.

Oracle SQL Developer is getting better all the time and it's new and improved formatter does this.

______________________________________________________________
WOW Gold|Wow Gold Kaufen|Diablo 3 Gold|Guild Wars 2 Gold

 

[Gustavo]

But PSD still doesn't.