Find a value and the position from the string.
Hi All,
Actually I have one table called test and it got 2 columns in it one is number and the other one is varchar2. now I need to find a particular value from a string and also the position of first position character of that searched value. For example, I need to search “Small” from the string “This is the small value” and also the position of that letter “S”.
The result should be ----
Value Position
Small 14
hare krishna
Alok