How to find whether the Exact string is present or not in a given string
Hi,
I'm facing some problem even after using INSTR function in Oracle.
The problem is
I have written the logic in the PL/SQL block which appends all the values fetched in a loop on the basis of whether the string is present or not.
For ex:
The first value fetched from the select query first is ABCDEFG which gets appended to a variable
The next value fetched is AB even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The next value fetched is BCDEF even this has to be appended to the variable since this exactly doesn't match with ABCDEFG.
The third Value fetched is ABCDEFG this will not get appended presently according to the logic which is correct.
So can you all please help me out in writing that piece of code to append the value fetched which doesn't exactly match with the existing string