Skip to Main Content

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!

How to remove commas...

user5737516Mar 3 2017 — edited Mar 10 2017

Hi Guys,

How do I remove a comma at the end of an output of a function that I've decoded?

Ex:

ID Category

1 Law,

2 Government, Law,

3 Science, Health, Finance,

P.S.

The category is basically a bunch of concatenated fields from a function to return if a person has law, govt, etc experienced.

Thanks.

[MODERATOR'S NOTE (BluShadow): Original message reproduced from reply #3, below.]

This post has been answered by ReemaPuri on Mar 4 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2017
Added on Mar 3 2017
14 comments
3,747 views