The 21c docs say:
13.63 SQLERRM Function
SQLERRM()
A SQL statement cannot invoke SQLERRM.
Are the docs suggesting we can't use SQLERRM() in a SELECT query?
If so, that seems incorrect:
SELECT SYS.STANDARD.SQLERRM(-1422) FROM DUAL;
--That query works as expected:
SYS.STANDARD.SQLERRM(-1422)
-----------------------------------------------------------------
ORA-01422: exact fetch returns more than requested number of rows
[1 row selected]
Idea: Could the docs be improved so that it's clear that we can use SQLERRM() in a SELECT query?
Related: Are certain kinds of Oracle functions only available in PL/SQL, not SQL?