How to extract the bind variable name from LIKE following sql queries
'SELECT NAME INTO :NAME FROM DUAL'
'SELECT * FROM DUAL WHERE (:NAME=FIRST_NAME)'
'SELECT * FROM DUAL WHERE :NAME IS NULL'
'SELECT * FROM DUAL WHERE :NAME||NAME=LAST_NAME'
'SELECT * FROM DUAL WHERE :one=10'
'SELECT * FROM DUAL WHERE :ONE>=10'
'SELECT * FROM DUAL WHERE :ONE<=10
Give some solution using SUBSTR,REGEXP_SUBSTR, Please answer quickely
best answer will be marked correct/helpful....
I want this output with function. Give some example of Substr/Regexp_substr
Yes I have tried the substr and search for first phrase i.e : but in ending seperator differes from query to query as i have given some of examples in my post above. Please tell me how to find then next occurrence of Non-alpha numeric character except underscore because bind variable can contains name with underscore character and also contains numbers also at end Like :Dinesh_singh1
help me out
thanks in advance.....