Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 18.4 'custom format' for NVL

user637346Apr 2 2019 — edited Jun 26 2020

Hello all,

I would like to format using custom format so that my queries do not break into several lines. Currently the formatter is formatting my NVL as below:

SELECT 1

   FROM dual

WHERE nvl(

         NULL,

         0,

         1

) = 0

I would like to format as below:

SELECT 1

   FROM dual

WHERE NVL(NULL, 0, 1) = 0

Comments
Post Details
Added on Apr 2 2019
29 comments
3,927 views