Q: Whole word search replace in SQL (Oracle) I've a string containing control block references in ORACLE FORMS like below:-
SELECT NAME,DESIGNATION,POSTING
FROM SCOTT.EMP
WHERE NAME LIKE :PARAM.COL1
AND DESIGNATION LIKE :PARAM.COL12
AND POSTING LIKE :GLOBAL.POSTING

My requirement is to traverse above string, look for colons and then using NAME_IN & REPLACE functions to get actual values.
Problem is that replacing :PARAM.COL1 replaces both instances i.e. :PARAM.COL1 & :PARAM.COL12.
Can anybody suggest how can I replace :PARAM.COL1 & :PARAM.COL12 correctly.
