How do you debug PL/SQL code?
Answer / samsudeen
When u execute the PL/SQL in putty u are using follwing
command
SQL > @samsu.sql
if not compile succeefully, u can use the follwing command
to debug the PLSQL.
SQL > show errors
its display the error name , line no and column no.
Is This Answer Correct ? | 2 Yes | 1 No |
Explain some new features available in jdbc 4.0?
What is 2 phase commit?
How to execute bulk number of queries at once?
What is preparedstatement in jdbc?
Is it possible to connect to multiple databases simultaneously?
What is the difference between Minus, and Intersect?
How do I insert/update records with some of the columns having NULL value?
Expalin the method of calling a stored procedure from jdbc.
What is meant by jdbc?
Does jdbc use odbc?
If you are truncated using JDBC, how can you that how much data is truncated?
Explain what should be done when a SQL exception is raised?