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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Replace a string variable value (replace '&' in the string to %26)

1016450Jun 18 2015 — edited Jun 18 2015

Hi All....I have an issue ...we are forming a url which has a string field with '&' in its value example: ST&G ....the url is erroring out.However if we replace thsi value by ST%26G it works as expected.I tried replace('ST&G','&') it asks to enter substitution value and outputs ST which is not what i need...i need the output to be ST%26G.Please suggest.

This post has been answered by odie_63 on Jun 18 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2015

Added on Jun 18 2015

7 comments

793 views