Oracle error line

SELECT to_char(a.LINE) || ' - ' || a.TEXT ERROR
FROM ALL_SOURCE a,
     ALL_ERRORS b
WHERE a.NAME = 'object_name'
  AND a.NAME = b.NAME
  AND a.TYPE = b.TYPE
  AND a.LINE = b.LINE
ORDER BY a.NAME, a.LINE;

Similar codes

-1 vote155 views1 answer
How to reset autoincrement in sqlite java
SQL
2 votes147 views1 answer
How to insert string variable into sqlite database
SQL
16 votes143 views3 answers
Delete row psql
SQL
0 vote108 views2 answers
Jupyter notebook connect to database
SQL
0 vote139 views1 answer
Oracle activate program
SQL
0 vote165 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote153 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
9 votes155 views4 answers
Mysql set id auto increment
SQL
0 vote113 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
3 votes161 views1 answer
Convert sqlite table to pandas dataframe
SQL