Beautifier: AND on new line

[Thijs Blaauw]

Is it possible to configure the beautifier so that AND's in the WHERE clause start on a new line.

For example:

select *
from a
where x = 1
and y = 2;

instead of:

select *
from a
where x = 1 and y = 2;

or

select *
from a
where x = 1 and
y = 2;

which now seems the default?

Regards,
Thijs Blaauw

 

[Marco Kalter]

No, but this is one of the new features in the upcoming 6.0 release.

 

[Thijs Blaauw]

Good news, thank you.

 

[baloo]

1, is possilbe to configure the beautifier, for number of column in select or insert on one line? for example max 3 columns on one line?
2, after each command add one new line? (if not exists)
3, replace example statemenst, are too small for demo beautifier functionality.
thanks ,
Baloo

 

[baloo]

1, is possilbe to configure the beautifier, for number of column in select or insert on one line? for example max 3 columns on one line?
2, after each command add one new line? (if not exists)
3, replace example statemenst, are too small for demo beautifier functionality.
thanks ,
Baloo

 

[Marco Kalter]

1. No, but you can use the "Fit" format, in which case items will be placed on 1 line if it fits within the right margin.

2. You mean an empty line between each command?

3. I'm not quite sure I understand, but you can modify the BeautifierPreview.cfg text file to change the demo PL/SQL for the beautifier options.

 

[baloo]

Hi Marco,
1, in 'FIT' format can be have on one line 12 columns, on second line 2 columns, on third line 7 columns. this format is bad for read. - for example insert select with 100 columns.
2, yes, if after command does not exists new line, beatifier append him .
3, ok.. i can replace this file. But your programmers now better, what is for demo necessary.
Thanks,