3 Replies Latest reply: Jan 11, 2013 9:57 AM by Askdineshsingh RSS

    how to find the bind variable select query

    Askdineshsingh
      How to extract the bind variable name from LIKE following sql queries
      'SELECT NAME INTO :NAME FROM DUAL'
      or
      'SELECT * FROM DUAL WHERE (:NAME=FIRST_NAME)'
      or
      'SELECT * FROM DUAL WHERE :NAME IS NULL'
      or
      'SELECT * FROM DUAL WHERE :NAME||NAME=LAST_NAME'
      or
      'SELECT * FROM DUAL WHERE :one=10'
      or
      'SELECT * FROM DUAL WHERE :ONE>=10'
      or
      'SELECT * FROM DUAL WHERE :ONE<=10

      Give some solution using SUBSTR,REGEXP_SUBSTR, Please answer quickely
      best answer will be marked correct/helpful....