How to divide query output into groups in oracle?

0 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,

---

what is primary key?

9 Answers  

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---

How to define an external table with a text file?

0 Answers  

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

Explain the use of ignore option in imp command.

0 Answers  

---

Can objects of the same Schema reside in different tablespaces.?

3 Answers  

---

How to use subqueries with the in operator using oracle?

0 Answers  

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---