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 anonymous block and named blocks?

3 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

display null value rows with out using null function?

8 Answers   Infosys,

---

in procedure how to return a value

3 Answers   Wipro,

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

when normalization is required

3 Answers   HCL,

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---