Answer / surya

Many of these wait events are tied to the internal implementation of Oracle and therefore are subject to change or deletion without notice. Application developers should be aware of this and write their code to tolerate missing or extra wait events.

The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:

SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;

What are the datatypes a available in PL/SQL ?

2 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Symphony, Accenture, BirlaSoft, CTS, Cognizant,

---

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

---

i don't want the message as 14 rows updated just it should update what it will do

4 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   Sail, ICICI, Saama Tech,

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

What are the default Oracle triggers??

2 Answers   Tech Mahindra, CGI,

---