Read ora error from alert.log using SQL statement

SQL> select ORIGINATING_TIMESTAMP, MESSAGE_TEXT from V$DIAG_ALERT_EXT where MESSAGE_TEXT like '%ORA-%';