Interested to Buy Any Domain ? << Click Here >> for more details...
how to debugg a procedure or package using
dbms_output.put_line in plsql
- 1 Answers
- 7882 Views
- Polaris, I also Faced
- E-Mail Answers
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 is left join in sql?
Can ddl statements be used in pl/sql?
What are the different dml commands in sql?
What is rename in sql?
What is %s in sql?
how to get a list of all tables in a database? : Sql dba
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is sql*loader and what is it used for? : aql loader
Why do we use set serveroutput on?
How many databases can sql express handle?
How do I count duplicates in sql?
What are triggers and its uses?
what is the difference between join and union? : Sql dba
How much does a sql dba make? : SQL DBA
Which is better cte or subquery?
