Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

formatter option- for join

user10439220Sep 19 2023

do I miss anything?

I can't get the formatter to have keyword join to start a new-line with bool combination like

select
t1.field1,
t2.field2,
t3.field3
from
table1 t1
join table2 t2 on t1.key = t2.key and t2.eff > sysdate
join table3 t3 on t1.key = t3.key and t3.eff > sysdate
;

it's messed up to

from
table1 t1
join table2 t2
on t1.key = t2.key and t2.eff > sysdate join table3 t3
on t1.key = t3.key and t3.eff > sysdate;

Comments
Post Details
Added on Sep 19 2023
10 comments
400 views