sql – What is the alternative to REGEXP_REPLACE to create a functional index?
Question: After migrating to Oracle 18c Enterprise Edition, functional index (FBI) creation fails. This is how the DDL for creating an index looks like: CREATE INDEX my_index ON my_table( UPPER (REGEXP_REPLACE (“DEPT_NUM”, ‘[^[:alnum:]]’, NULL, 1, 0))); I am getting the following error: ORA-01743: only pure functions can be indexed 01743. …
sql – What is the alternative to REGEXP_REPLACE to create a functional index? Read More »