Interested to Buy Any Domain ? << Click Here >> for more details...
10. Display the client number, order date and shipping date
for all orders where the shipping date is between three and
six months after the order date.
- 3 Answers
- 6952 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhajit acharyya
select clientnumber,ordate,shipping date from order where
months_between(shipping date,ordate) between 3 and 6;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do I connect to oracle?
What's dateware house and what's clustor with practicle example
Does oracle partitioning improve performance?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to rebuild an index in oracle?
How to define a cusotmer as a supplier in ORACLE R12
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Is it possible to split the print reviewer into more than one region ?
what is the difference between restoring and recovering?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How does oracle handle read consistency?
How to select an oracle system id (sid)?
What are triggers in oracle?
Can I create users through internet explorer in oracle 10g?
