Skip to content

derevyov/plsqlDeveloperPluginUtil

Repository files navigation

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

About

PLSQL Developer plugin replace param

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published