oracle show error line number
Solutions on MaxInterview for oracle show error line number by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle show error line number"
Sacha
20 Sep 2017
1SELECT to_char(a.LINE) || ' - ' || a.TEXT ERROR
2FROM ALL_SOURCE a,
3 ALL_ERRORS b
4WHERE a.NAME = 'object_name'
5 AND a.NAME = b.NAME
6 AND a.TYPE = b.TYPE
7 AND a.LINE = b.LINE
8ORDER BY a.NAME, a.LINE;similar questions
ora 00001 error catch plsqlshow line number in sql serverwrite a pl 2fsql to print even numbers upto 100 divide by zero error in sqloracle to numberoracle sql how to overcome 999 limit for inoracle sql number to varchar2oracle no data found error codeoracle list dates without weekendsif not null pl sql oracleoracle simple quoteoracle pl sql how to see dbms output put lineoracle sql all days except weekendsraise application error in oraclecall function sql oracle with output put lineoracle number to percentagehow to know the character set of an oracle databesoracle run duration to numberoracle sql developer script output limitoracle output lineoracle current sequence valuesql management studio display line numbershow to check nls format in oracle your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful