Forum Stats

  • 3,707,827 Users
  • 2,240,880 Discussions
  • 7,839,830 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

How to disable the auto-inserted icons/images?

mNemmNem Posts: 1,380 Gold Trophy

Can someone please suggest how to disable (or even a workaround) those images or icons from auto-inserted when the text/code has something like ( + ) or : ) or @?

Thanks.

Billy Mahoney

Best Answer

  • Dude!Dude! Posts: 22,824 Blue Diamond
    edited July 2019 Accepted Answer

    The editor does not allow the user to turn off auto format options and this can be quite annoying.

    I suggest the following:

    Switch to the "advanced editor"

    Note: it's not available when you comment from your Inbox but when you "reply" after opening the thread.

    Choose Syntax Highlighting from the  >> menu.

    For example:

    (+)

    These and other annoying issues have already been mentioned several times in the past. Apparently on one is able to address these problems..

    Billy Mahoney

Answers

  • BluShadowBluShadow Moderator Posts: 40,813 Red Diamond
    edited July 2019

    There's no easy workaround.  Sometimes you can try and fool the editor by typing it with spaces and then removing the spaces etc. later. but that rarely works as it tends to re-parse the text when you save it anyway.

    The simplest way to avoid getting for your outer joins is to not use it.  That may sound flippant, but joins in SQL are best done in ANSI syntax rather than oracle specific syntax (in fact there are some thing you can do with ANSI syntax that you can't do with oracle syntax, such as outer join on more than one table, or include OR conditions etc.)

    So, instead of:

    select d.dname, e.ename

    from   dept d

          ,emp e

    where d.deptno = e.deptno(+)

    you would write:

    select d.dname, e.ename

    from   dept d

          left outer join emp e on d.deptno = e.deptno

    As for the other icons, you just have to put a side note with your text/code to explain what it should be.

    Edit: And no, don't ask me how my code above didn't convert the outer join automagically to a , it just didn't for some reason, perhaps because it was straight after the text and there was no space between the column name and the symbol.  Personally though, I'd use ANSI syntax.

Sign In or Register to comment.