Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Catalog · How the catalog works
Anything · Lazarus or Delphi
Random projectRandom project

plsqlDeveloperPluginUtil

PLSQL Developer plugin replace param

View on GitHub

Member rating

No ratings yet.

Sign in to rate this project.

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

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