Table shows examples of various evaluations involving nulls in conditions. Table Conditions Containing Nulls. For the truth tables showing the results of logical conditions containing nulls, see Table , Table , and Table Do not use null to represent a value of zero, because they are not equivalent.
Note: Oracle Database currently treats a character value with a length of zero as null. What I wanted to know is that when oracle does a greatest does is add the ascii values of each charecter or it concatenates it while comparing. August 26, - pm UTC. DE is because it starts with D.
Now, replace A with 1, B with 2 and so on. It is consistent. It is done the same way for all strings, you compare byte by byte until you find bytes that are different - the byte that is different with the higher ascii code represents the "bigger" string.
One of the more convenient way of using greatest function with dates is NVL with least date. Hi, My job was to find out the least of two dates, of course skipping nulls. I tried this. Hi tom, I tried the following scenarios with greatest. Why it is giving the error "Invalid number" when the first value is number and others are strings.
October 11, - pm UTC. Raj A Raj A 5 5 gold badges 13 13 silver badges 28 28 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Llama Mr. Llama 19k 2 2 gold badges 50 50 silver badges bronze badges. David Faber David Faber Alex Poole Alex Poole k 9 9 gold badges silver badges bronze badges. Frosty Z Frosty Z Dennis A. You could try 11g : with x as select 1 as id, sysdate - 30 as col1, sysdate as col2, sysdate as col3,null as col4, sysdate-1 as col5 from dual union select 2 as id, sysdate - 10 as col1, sysdate as col2, null as col3,null as col4, sysdate as col5 from dual union select 3 as id, null as col1, null as col2, null as col3, null as col4, null as col5 from dual select id, max dates from x UNPIVOT INCLUDE NULLS dates FOR colname IN col1,col2,col3,col4,col5 group by id.
Hedinn Hedinn 4 4 silver badges 7 7 bronze badges. I tried this.. HRawashdeh HRawashdeh 1. Sign up or log in Sign up using Google. Sign up using Facebook.
0コメント