Interested to Buy Any Domain ? << Click Here >> for more details...
How will you debug your procedure? If your procedure is
around 2000 lines and the expected output is 10 and we get
only output 5.So how will you debug it?
Somebody pls give the correct answer?
- 2 Answers
- 12718 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / arthi
use the following code to debug the huge line of code
DBMS_OUTPUT.PUT_LINE
(dbms_utility.format_error_backtrace||' : '||sqlerrm);
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what are the properties and different types of sub-queries? : Sql dba
Does execute immediate commit?
How bulk collect improves performance?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the difference between sql, mysql and sql server?
What is schema in sql?
What makes a good primary key?
How do you use collections in procedure to return the resultset?
Does inner join return duplicate rows?
What are the types of queries in sql?
What is not equal in sql?
How can I speed up sql query?
Can sql function call stored procedure?
How do you optimize a stored procedure query?
What is trigger in flip flop?
