HI Raaj,
Thanks. I know about to_char. but when you use it in the Query which fetches more than 10,000 rows. it sucks. So, that's why i want to know whether Oracle has any built in functions for the same.
Thnx.
Giri.