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 |
Is sql a scripting language?
there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?
What is sqlexception in java?
How to use distinct and count in sql query? Explain
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is oracle and pl sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How do you retrieve the second highest salary from a table?
what is the stuff function and how does it differ from the replace function? : Sql dba
If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?
Where the sql database files are stored?
how many sql ddl commands are supported by '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)