order by- strange behaviour
Hi,
I am getting the following output when i use the order by clause.(Oracle 9i unix 5.8)If i remove the $ symbol it works fine.
Select * from emp order by salary;
Name Salary
----- --------
ABC $1000
DEF $123
GHI $1345
May i know the reason please.
Edited by: Kamesh on Feb 24, 2011 8:48 AM