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.