PLSQL Developer Plugin. Replacing :param with ¶m and back (excludes comment text and single quotes)
Copy files from folder name "Release" to "PLSQL_DEVELOPER_HOME/PLUGINS"
/*Replacing parameters :param with ¶m and vice versa
except comments and ':' in text*/
SELECT t.*, :PARAM
FROM TABLE_NAME t
WHERE t.tir = :PARAM
AND t.time = TO_CHAR('02:33', 'HH:MI')
and decode('str', :param, 'str2')
/*in comment :param*/
/*in the comment :param and
more text on another line*/
-- :param
Video lesson on PL/SQL Develper https://youtube.com/playlist?list=PLHfFGvt0iNuCxNVcl57sIrDn5GyVoF-mR