Oracle SQL*Plus has a very usefulsubparameter to the column parameter called NEW_VALUE. TheNEW_VALUE directive allows you to store data retrieved from anOracle table as a variable inside the SQL*Plus ...
It also lets you do some string-concatenation tricks, like the one I posted. RE: where it executes, it'll run in whatever database you're currently in. Note that you could just do "exec @SQL", but ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results