[raghu408]

If i have a string like :

update employee
set wtKey = name||pno||id
where id is not null

Then my API should return this when i pass "||"

name||pno||id

I tried doing it using ' ' as dilimiter and check to see if the parsed string has || but that won't work when the above update cmd is written in the following manner:

update employee
set wtKey = name || pno || id
where id is not null

(or)

update employee
set wtKey = name|| ' ' ||id
where id is not null

Is there any API or third party stuff that can perform such operation instead of we parsing it based on some assumptions.
Any help would be appreciated