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
- 7422 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
Why do you use stored procedures and state some of its disadvantages?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is a user account in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Differentiate between post-database commit and post-form commit?
How to delete a column in an existing table in oracle?
What is oracle used for?
what are archived logs?
How to store only time; not date and time?
What is oracle host variable?
What is truncate oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are the different types of trigger and explain its various uses and functions?
what are bitmap indexes? How does they work?
Is oracle a programming language?
