I'm an Oracle newbie. I have a column in my table that contains a pipe(|)-separated string such as this:
uguyguyguyguyguy|0737494110|[email protected]|E:\PROD_ActionMarketer\Program\Apsis\ApsisREST.exe|E:\PROD_ActionMarketer\Temp\TempApsisAdmin.skv|SENDEMAIL|"LIST=Daily SMS SPL"|1015832
As you see the penultimate value begins with "LIST=". I want to extract the value after this string i.e. "Daily SMS SPL" to be able to compare it with another column in another table. I want to obtain this value ("Daily SMS SPL") using a SELECT
query if it's possible.
So let's say the table name is MYTABLE
and the name of the column is MYCOLUMN
.
SELECT SUBSTR(surname,1
,INSTR(surname,'"',1,1)-1) FROM
(SELECT SUBSTR(column
,INSTR(column,'LIST',-1)+5
) AS surname
FROM table)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments