[quote=Marco Kalter]Okay. One more question: would this be restricted to single DML statements (select, update, insert, delete)?[/quote]

For me personally, yes. Most of the time it's transferring a big cursor to a sql window and replacing variables and package constants in order to execute that query and modify join/where conditions to find out why an expected row got filtered out or in order to use the explain plan window etc. Or even to check if the result looks right when modifying those cursors inside the pl/sql routines.

So basically it's just a fast transfer from pl/sql to running those DMLs in a sql window. That is like 95% what I would need a feature like this for.

But I guess it could be useful for concatenated strings too, especially in the context of dynamic sql, even with merged single quotes, which were used to escape those etc. But most of the time those are smaller statements which don't take that much time to replace by hand.

Last edited by aLpenbog; 03/25/20 05:46 PM.