0

how to know ASCII code of single quote in sql oracle using ASCII() i tried select ASCII(''') from dual; but it showing an error which escape character can be used for this

user3135829
  • 33
  • 1
  • 1
  • 5
  • possible duplicate of [How to handle a single quote in Oracle SQL](http://stackoverflow.com/questions/2875257/how-to-handle-a-single-quote-in-oracle-sql) – MarioDS Jul 01 '14 at 13:21
  • 3
    Also, the ASCII code for a single quote is 39. You can just look it up... – Matt Gibson Jul 01 '14 at 13:22

1 Answers1

1

Simply use two single quotes to escape it:

select ASCII('''') from dual;

Looks a little weird but that should do it.

MarioDS
  • 12,895
  • 15
  • 65
  • 121
  • @user3135829, No problem but I'd rather get "thanks" in the form of you accepting my answer :) see the [faq] for details. – MarioDS Jul 01 '14 at 13:43