SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

format mask to null of space

469636Feb 15 2011 — edited Feb 16 2011

I'm using Oracle 10g, I have a filed with format mask 09.00
My value is 1.1 so it appears as 01.10
I want to see 1.10 which format mask should Ise, I do not want to do trim

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2011

Added on Feb 15 2011

5 comments

540 views