Skip to Main Content
Forums

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.

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

Processing

Post Details

Added on Dec 21 2022
#sql, #sqldeveloper, #sqlplus
4 comments
211 views
1 mention