How to trace the errors in pl/sql block code?
Answer Posted / swapna
User_Errors table
OR
show error on sql promt.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is sql*loader and what is it used for? : aql loader
What are the types of subqueries?
Why is pl sql needed?
how do you know the version of your mysql server? : Sql dba
What is file based approach?
Write a query to display the current date in sql?
Is primary key is clustered index?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is a data definition language?
What is hibernate and its relation to sql?
What is the use of function "module procedure" in pl/sql?
What is error ora-01000: maximum open cursors exceeded
Which command is used to delete a trigger?
What is sql in oracle?
What is sp_helptext?