[color=blue]判断两个日期相减,是否大于某个数[/color]
[color=blue]判断多个字符之间的大小[/color]
select sign(round(to_number(sysdate-to_date('2007-10-8 9:33:34','yyyy-mm-dd hh:mi:ss'))*24-24)) as d from dual
[color=blue]判断多个字符之间的大小[/color]
select least('a','我','tt') from dual
select greatest('a','我','tt') from dual