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 to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently
if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time
what is explain plan?, given an example...
What is index example?
What is the maximum number of columns in sql table?
i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.
what are the non-standard sql commands supported by 'mysql'? : Sql dba
how many sql dml commands are supported by 'mysql'? : Sql dba
What is sql query optimization?
How do I remove sql developer from windows 10?
Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index
What is the difference between partition and index?
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)