I'm a sed newbie and need this:
DBMS_OUTPUT.PUT_LINE("text " ||table1|| " moretext: " ||table2||);
To be converted in something like this:
RAISE DEBUG "text % moretext: %";
(^^The two '%' signs represent table1 & table2).
So, I need to replace all values on that line surrounded by || in % signs, and all other text ( 'moretext:' ) just needs to be put in the string, in the right place.
I find it really hard to find the right syntax for this sed command, so if someone could give me some hints I would be really happy
ps: please consider that there could be more than 2 extra fields, and more textfields.