how to debugg a procedure or package using
dbms_output.put_line in plsql
Answer Posted / bunty
dbms_output.put_line can be used in Packages, Procedures or
triggers to display message or variable values which can be
used as debugging tool.
Cheers,
Bunty
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the dml statements?
What are different types of statements supported by sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Can we change the table name in sql?
How do you write a subquery?
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
How can you know that statistics should be updated?
What is cartesian join in sql?
Which normal form is best?
How many functions are there in sql?
What is difference between my sql and sql?
What are the built in functions of sql?
What is the process of debugging?
explain about mysql and its features. : Sql dba
Explain the structure of pl/sql in brief.