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?
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
What is the exact use of Collections?
How do we create privileges in oracle?
How to select some columns from a table in oracle?
Explain the use of show option in imp command.
What is the meaning of recursive hints in oracle?
What is catalog in Oracle?
How can we find out the duplicate values in an oracle table?
Give syntax for SQL and ORACLE joins.
What is difference between cartesian join and cross join?
What to do if the startbd.bat failed to start the xe instance?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to omit columns with default values in insert statement in oracle?
What privilege is needed for a user to connect to oracle server?
How to check your oracle database 10g xe installation?
What is user managed backup in Oracle?