What are the database administrators utilities available?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---

How to view the data files in the current database?

0 Answers  

---

How to get a list of all tables in the database?

1 Answers  

---

Can we write insert statement in function in oracle?

0 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

What is ordinary table in oracle?

0 Answers   MCN Solutions,

---

What are the differences between number and binary_float in oracle?

0 Answers  

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,

---