Answer / Nisha Bharti

A directory object in Oracle is a named collection of one or more operating system-specific directories. Directory objects allow you to store external files that can be referenced by SQL statements, such as UTL_FILE or DBMS_LOB operations.

What are the trigger associated with image items ?

1 Answers   Oracle,

---

What is rich query?

1 Answers  

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---

what is cartesian product?

2 Answers  

---

you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??

2 Answers   BirlaSoft,

---

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,

---

Explain the blob datatype?

1 Answers  

---

What is Java Pool in Oracle?

1 Answers   MCN Solutions,

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1 Answers   Wipro,

---

What are temporal data types in oracle?

1 Answers  

---

How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?

2 Answers   Infosys,

---

What is snapshot is too old? Give and example for better understand.

1 Answers   TCS,

---