SQL & PL/SQL

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!

Regarding ASCII of numbers treated as strings

user10913793Oct 28 2018 — edited Oct 30 2018

Hello,

I am preparing for 1Z0-071 and I had a question in ' Comparing Datatypes' portion of Restricting and Sorting Data.

I am aware of ASCII values for characters and numbers and I know 'A' < 'Z' , 'Z'<'a' and also 'a'<'z'.

my question is how '1'>'100' and how '2'>'10'

ascii of numbers 0-9 runs from 48-57. what is ascii of string 2 i.e. '2'? unable to find any explanation regarding this

Please help

Added on Oct 28 2018

9 comments

1,654 views