Answer / orawhiz

Private database link is created on behalf of a specific user.

A private database link can be used only when the owner of
the link specifies a global object name in a SQL statement
or in the definition of the owner's views or procedures.

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  

---

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

2 Answers   Oracle, SAH,

---

Explain what are clusters?

0 Answers  

---

What is Database Link ?

2 Answers  

---

What is meant by a deadlock situation?

0 Answers  

---

How to use "while" statements in oracle?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

How to define an explicit cursor in oracle?

0 Answers  

---

What is SAVE POINT ?

5 Answers  

---

How to create tables for odbc connection testing?

0 Answers  

---