Thread: Extract String value

Hello ,

I am trying to get the value after second pipe from the following value using SQL in Oracle with instr function .. it's not working for me

Could some one help me with syntax..

this is the value 1|1|True
this is the value 2|2|False

I need to get True , False after second pipe form the value..

Thanks,
Suji

try this ....

select substr(column name,instr(columnname , '|' , -1 )+1) from table name