SQL>
SQL> COLUMN name FORMAT a22
SQL> COLUMN line FORMAT 9999
SQL> COLUMN text FORMAT a30 word_wrapped
SQL> SELECT name, type, line, text
2 FROM user_errors
3 where rownum < 2
4 ORDER BY name, type, sequence;
NAME TYPE LINE TEXT
---------------------- ------------ ----- ------------------------------
WAIT PROCEDURE 3 PL/SQL: Statement ignored
SQL>