Its working fine. Thanks a lot once again.
suresh...could u do one more help for me?
How to store & retrieve value from number(20,2) in oracle. for ex. i neet an output as 123456789012345678.99 but im getting only 1.23456789012346E17.
kindly check my new post (P2P Forum > Database > Oracle > Number(20,2) Rounding off Problem) for detail and help me. thanks a lot.