SkillAgentSearch skills...

PlsqlDeveloperPluginUtil

PLSQL Developer plugin replace param

Install / Use

/learn @derevyov/PlsqlDeveloperPluginUtil
About this skill

Quality Score

0/100

Supported Platforms

Universal

README

PLSQL Developer plugin replace param

PLSQL Developer Plugin. Replacing :param with &param and back (excludes comment text and single quotes)

Copy files from folder name "Release" to "PLSQL_DEVELOPER_HOME/PLUGINS"

T

Test sql

/*Replacing parameters :param with &param 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

View on GitHub
GitHub Stars6
CategoryData
Updated24d ago
Forks0

Languages

Pascal

Security Score

70/100

Audited on Mar 5, 2026

No findings