i have a field where the value is stored in a specific format. and i want to extract a portion from it as below. I tried using regex expression but while running the query it takes a long time. Performance degrage. Is there a better way to write .
[code]
field
ORDER_NO=F10001^
ORDER_NO=A10001^
select app_sign from approval_routing_tab b where lu_name ='CustomerOrder' and REGEXP_SUBSTR (b.KEY_REF,'=([^^]+)',1, 1,NULL,1) = 'F10010'
[/CODE]