select to_char(dat) from(select dat from temp13 where upper(dat) =lower(dat) order by to_number(DAT)) union all select dat from( select dat from temp13 where upper(dat) <>lower(dat) order by dat) Pcode 10098 10054 20034 154 132 123 2004 2003 As23 Dr45 Ac45 OUTPUT 123 132 154 10034 10054 10098 2003 2004 20034 As23 Ac45 Dr45
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)