Answer Posted / s.maheshbabu

quarry inside a quarry is called sub quarry.when sub quarry
is also called nested quarry.
co-related sub quarry is one as inner quarry is evaluated.is
anther result of inner are evaluated.
nested quarry is multiple time of one outer quarry.

ex;-quarry used in()caused co-related quarry.
quarry used with=operator is nested quarry.

Can the query output be sorted by multiple columns in oracle?

992

---

How many anonymous blocks can be defined?

1184

---

Can we store images in oracle database?

1005

---

What is the difference between "as" and "is" in an oracle stored procedure?

987

---

How to convert dates to characters in oracle?

1040

---

Explain the characteristics of oracle dba?

1120

---

What is parameterized cursor in oracle?

1150

---

Where do we use decode and case statements?

1011

---

How to define and use table alias names in oracle?

941

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

---

What are the limitations of check constraint?

1033

---

What are the various types of snapshots ?

1027

---

Explain the use of show option in imp command.

1096

---

What is a proxy object?

1061

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2208

---