How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

0 Answers  

---

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

---

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,

---

What are main difference between Stored Procedure and Functions.

6 Answers   CA, Metric Stream,

---

Explain coalesce function?

0 Answers  

---

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 Answers  

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---

What is a Data File ?

1 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

What is an Oracle sequence?

1 Answers  

---

Can we create trigger on materialized view in oracle?

0 Answers  

---

What is a table in oracle?

0 Answers  

---