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;

How to make a copy values from one column to another in sql?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

What is a primary key sql?

0 Answers  

---

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

---

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

What are the different types of database management systems?

0 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

What is pl sql in dbms?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

What is difference between hql and native sql?

0 Answers  

---

Explain what is a subquery ?

0 Answers  

---