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 are sql commands classified?
What is sql*plus?
Why primary key is required?
How do I create a sql database?
What is row_number () in sql?
What is intersect?
What is break?
write a query find which rows of a table is updated on 2 days before?
How to select all records from the table?
What are different methods to trace the pl/sql code?
Which operator is used in query for pattern matching?
how would you get the current date in mysql? : Sql dba
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)