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 number

19023Sep 20 2006 — edited Sep 21 2006

Hi,

I've got a VARCHAR2(22) column wiht values like 'XXX+170000000000000225'. These strings are format numbers.

xxx --> currency (3 pos.)
+ --> sign (1 pos.)
1700000000000022 -->amount (17 pos.)
5 --> decimal position (1 pos.)

The actual number would then be 17000000000.00022.

Anybody a good suggestion on how to transform these strings to numbers? I do not think it can be done easily with TO_NUMBER and a format mask. All suggestions are welcome.

Regards
Bram

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 19 2006

Added on Sep 20 2006

8 comments

828 views