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 is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---

Is sql injection illegal?

0 Answers  

---

What is Overloading of procedures ?

2 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

how to create temparary sequence

2 Answers   TCS,

---

What is the difference between local variables and global variables?

0 Answers  

---

Talk about views

10 Answers   Polaris,

---

What is lexical units in pl sql?

0 Answers  

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

Can I learn sql in a week?

0 Answers  

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---