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!

Strip comma from a numeric field

734819Aug 20 2012 — edited Aug 20 2012

Hi all,

Will you please help me providing sql statement to strip commas from a number/numeric field in the BI repository logical column? I do not want to use cast function to convert to character because we need to keep that field as numeric.
I could only find string expressions to remove commas. I appreciate your help.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 17 2012

Added on Aug 20 2012

12 comments

6,578 views