how to debugg a procedure or package using
dbms_output.put_line in plsql
Answer / 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 |
how can stop the sequence with mention the max value and with out mention the max value
Why is stored procedure faster than query?
Can we use delete in merge statement?
Are subqueries better than joins?
How to Execute a Package in PL/SQL.?
How do I truncate a word?
What are the operators used in select statements?
explain about mysql and its features. : Sql dba
What is cte?
What is latest version of sql?
How do you handle exceptions. Give the syntax for it?
How can I create a table from another table without copying any values from the old table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)