How can you debug your PL/SQL code? – InterviewSolution

InterviewSolution

1.	How can you debug your PL/SQL code?
Answer» We can USE DBMS_OUTPUT and DBMS_DEBUG statements for DEBUGGING our code: DBMS_OUTPUT PRINTS the output to the STANDARD console. DBMS_DEBUG prints the output to the log FILE.

Discussion

No Comment Found

Related InterviewSolutions

Is it possible to declare column which has the number data type and its scale larger than the precision? For example defining columns like: column name NUMBER (10,100), column name NUMBER (10,-84)
In what cursor attributes the outcomes of DML statement execution are saved?
What is the difference between a mutating table and a constraining table?
How can you debug your PL/SQL code?
What are COMMIT, ROLLBACK and SAVEPOINT statements in PL/SQL?