Hello again, folks.
Is it possible to reduce the error output?
[SYSTEM@a22x] SQL> select count(*) from dba_users where oracle_maintaned <> 'Y';
Erreur commençant à la ligne: 1 de la commande -
select count(*) from dba_users where oracle_maintaned <> 'Y'
Erreur à la ligne de commande: 1 Colonne: 38
Rapport d'erreur -
Erreur SQL : ORA-00904: "ORACLE_MAINTANED" : identificateur non valide
https://docs.oracle.com/error-help/db/ora-00904/00904. 00000 - "%s: invalid identifier"
*Cause: The identifier or column name entered was invalid.
*Action: Ensure the following
More Details :
https://docs.oracle.com/error-help/db/ora-00904/
[SYSTEM@a22x] SQL>
10 lines. Too much info, some redundant.
The older sqlplus output was way cleaner :
SQL> select count(*) from dba_users where oracle_maintaned <> 'Y';
select count(*) from dba_users where oracle_maintaned <> 'Y'
*
ERREUR à la ligne 1 :
ORA-00904: "ORACLE_MAINTANED" : identificateur non valide
SQL>
Only 3 lines. Error way easier to spot. No unnecessary information.
My personal opinion: no need for all those lines nor reference to websites with the error code. I believe everyone will ask google or chatgpt for it if needed anyway.
En passant, just out of curiosity I clicked the first link (there were two) on the error message above and, not to be mean but… lol
Invalid address. I think it's hard to keep them hardcoded in the tool itself, so shouldn't we just take it away? Cleaner output, easier for the user, less maintenance/updates for the developers.
I vote for restoring the original sqlplus simpler error output. Maybe add an option like -D or --verbose to have all this as extra information for debugging purposes, but default to the cleaner one.