Answer Posted / 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;

Why is there a need for sqlcode and sqlerrm variables?

1046

---

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..

2496

---

What is a subquery in sql?

1038

---

How do I count rows in sql query?

988

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1058

---

What are the different datatypes available in PL/SQL?

1083

---

How do you write an inner join query?

952

---

Can we group by two columns in sql?

996

---

Is sqlite good enough for production?

992

---

What is a table in a database?

1045

---

How do I make my sql query run faster?

941

---

What is the use of nvl function?

1198

---

When are we going to use truncate and delete?

987

---

What is sql and how does it work?

1170

---

How many types of index are there?

1040

---