yes its possible...u can use the date functions select * from table

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?

Question Posted / jas

2 Answers
7551 Views
Philips, I also Faced
E-Mail Answers

Answer Posted / jas

yes its possible...u can use the date functions
select * from table_name where col_name
between add_months (trunc(sysdate,'MONTH')-3)
and trunc(sysdate,'MONTH')-1

try usgin this might help..

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How does oracle handle read consistency?

1153

How to grant create session privilege to a user in oracle?

1055

What do you mean by redo log file mirroring?

1071

What is Segment Advisor in Oracle?

1148

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1125

Explain the difference between sap and oracle?

1087

Is it possible to insert comments into sql statements return in the data model editor ?

2638

Explain about achiever in sql?

1086

Explain what does a control file contain?

1166

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173

How to install oracle database 10g xe?

1064

Can we create trigger on materialized view in oracle?

1045

Â What are the oracle DML commands possible through an update strategy?

1106

How to use "if" statements on multiple conditions?

1217

Are truncate and delete commands same? If so why?

1204