Skip to Main Content

Adding a String to middle of string.

AnishRVDec 21 2022

Need a dynamic query to add a new operation code to the existing operation chain string.
Operation_string = '1000-->1150->1200->8000'
Excepted Operation string based on some specific items.
New_Operation_string = '1000-->1050->1150->1200->8000'
'1050' needs to be added existing value.
I can't use pl/sql for a loop because of limitations from our end. here.
Looking for dynamic SQL to add this value.

This post has been answered by Marwim on Dec 21 2022
Jump to Answer
Comments
Post Details
Added on Dec 21 2022
4 comments
77 views