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
- 7868 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
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is a recursive stored procedure?
What is the difference between distinct and unique in sql?
State some properties of relational databases?
What are sql functions? Describe in brief different types of sql functions?
What is the use of desc in sql?
Can we call procedure in select statement?
What is the difference between cross join and natural join?
What are sql commands?
What is a constraint? Tell me about its various levels.
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is a sql statement?
What is a data definition language?
Can we perform dml in function?
What is sql character function?
