title: How to substitute bind variable in pl/sql developer tool
body: <p>I would like to run a SQL script in PL/SQL developer as following example.</p>
  
  <pre><code>variable vTest varchar2;
  (exec/set) :vTest := 'ABC'
  select :vTest from dual;
  select :vTest ||'XYZ' from dual ;
  select * from table  where columnname = :vTest;
  </code></pre>