I'm trying to do something like this
SUBSTR(err_descr,1,INSTR(err_descr,'('))
in an SQL window. Unfortunately, Developer is seeing the '(' as another open parenthesis and from this statement on, every time I type a comma it is giving me the drop-down list choice items for the SUBSTR function...