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 vote87 views1 answer
Mysql show attributes of a table
SQL
0 vote123 views1 answer
Qt qsql check if table exist
SQL
18 votes149 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote133 views1 answer
Tsql pad left
SQL
1 vote132 views2 answers
Backup table mssql
SQL
-1 vote135 views2 answers
Mysql get day of week
SQL
15 votes125 views4 answers
Mysql where value is null
SQL
0 vote127 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote135 views1 answer
Postgressql uuid
SQL
5 votes148 views3 answers
Show indexes mysql
SQL