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;

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

How can we avoid duplicating records in a query?

0 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

What language is oracle sql developer?

0 Answers  

---

How you improve the performance of sql*loader? : aql loader

0 Answers  

---

What is use of term?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is the primary use of normalization?

0 Answers  

---

what is meant by tuning and tk proof?

2 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---