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!

[4.2EA] Formatter error

SentinelSep 26 2016 — edited Sep 26 2016

Thanks to Alex Nuijten over at his Notes on Oracle blog for this entertaining query that socks it to the query formatter:

select listagg (b)

    within group (order by null) ||' Batman'

from (select 0f/0 b

    from dual

connect by level <= 14

  );

Hitting Format (CTRL-F7) yeilds the following results:

select listagg (b)

    within group (order by null) ||' Batman'

from (select 0f

/*** Syntax Error at line 2, column 16

from (select 0f/0 b

                ^^^ 

Expected:

***//0 b

    from dual

connect by level <= 14

  );

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2016
Added on Sep 26 2016
1 comment
109 views