May-29-2024, 08:57 PM
SELECT REGEXP_SUBSTR(SYS_CONNECT_BY_PATH(nom, '\\'), r'[^\]+', 3, 4)The first literal
\
must be escaped with another \
.Using a raw string (sometimes called regex string) does not help, because after the backslash comes the quotation mark.
The second string literal can be written as raw string, because the quotation mark does not follow after the backslash.
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
All humans together. We don't need politicians!