ORA-00996: the concatenate operator is ||, not |
Cause: A single bar (|) was interpreted as an attempt to specify concatenation, but the concatenation operator is a double bar (||)
Action: Enter a double bar (||) for concatenation or remove the single bar (|) if concatenation was not intended