This discussion is archived
3 Replies Latest reply: Jan 11, 2013 7:57 AM by Askdineshsingh RSS

how to find the bind variable select query

Askdineshsingh Explorer
Currently Being Moderated
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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points