(e.g. Jameson, /fp_he/dual_user/sling/omni_trigger).
I want to run a query that returns two columns, the server in one and the path in the other.
So I've been trying to do this with regular expressions. Here is what I have so far. Is this even an efficient way of going about this? I know that ideally I should create my table differently, but that is not an option here.
SELECT REGEXP_SUBSTR(parm_value, '*\/') AS server, REGEXP_SUBSTR(parm_value, '\/*') AS path FROM run_type_parms WHERE REGEXP_LIKE (s.parm_value, '\/*');