Substr and instr are frustratingly limited but well defined. Regex specs can differ. Random syntax test sites from Google might not match Oracle’s implementation, which may change between versions.

Why cant I trim my substring (Oracle SQL) IO_303 Jan 28, 2011 Jump to latest Follow Reply ...