About the comparison of characters in Oracle

The 1.Oracle comparison string is based on the ASCII code, the first letter of the ASCII size comparison if the equivalence is again compared to the next;

function to illustrate:

CREATE OR REPLACE FUNCTIONMinormax (para1inch VARCHAR2, Para2inch VARCHAR)return  Number asbegin  ifPara1>Para2 Then      returnpara1; Else      returnPara2; End if;EndMinormax;

Compare the sizes of 10 and 3 first

SELECT Minormax ('ten','3' from dual;

In comparison of size 11 and 12

View 10,12,11 and 1 Their results are the first ASCII code, so they compare 1, and 3>1.

About the comparison of characters in Oracle