Can we debug stored procedure?

0 Answers  

---

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

---

Explain ddl statements in pl/sql?

0 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

What is view? Can we update view

0 Answers  

---

How much ram can sql express use?

0 Answers  

---

Are sql connections encrypted?

0 Answers  

---

What is sql profiling in oracle?

0 Answers  

---