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
- 7411 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
what is Single Byte Overhead...?
How to use in conditions in oracle?
What happens to the data files if a tablespace is dropped?
How to create additional tablespaces for an new database?
What is pragma autonomous transaction in oracle?
How to bring a tablespace online?
What is Java Pool in Oracle?
What are operators in oracle?
What is oracle instant client?
What is concurrency in oracle?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is a procedure in oracle?
How to load data through external tables?
Explain do view contain data?
What privilege is needed for a user to create tables in oracle?
