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!

Convert char to number

hartford27Jan 23 2009 — edited Jan 23 2009

I am using to_char("FOMS_DFL"."Adjustment Hours",'9999.9') to my desired format. But I am not able to sum the Adjustment Hours. Can i convert the to_char("FOMS_DFL"."Adjustment Hours",'9999.9') to number using any function.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2009

Added on Jan 23 2009

6 comments

1,066 views