Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7436 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
How to delete all rows a table in oracle?
how to make an oracle object
What is an anonymous block?
How to increment dates by 1 in oracle?
How can I introduce multiple conditions in like operator?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is a table index in oracle?
What to do if the startbd.bat failed to start the xe instance?
Can the query output be sorted by multiple columns in oracle?
What are the differences between char and nchar in oracle?
Differentiate between pre-select and pre-query?
Is oracle a programming language?
What is enter substitution variable in oracle?
Why oracle is used?
