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
- 5706 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mk
elect clientnumber,ordate,shipping date from order where
datediff(mm,Orderdate,Shipping date) In (3,6);
| Is This Answer Correct ? | 0 Yes | 0 No |
why pl sql doesn't support retrieving multiple records
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to write a query with a left outer join in oracle?
What are the different windows events activated at runtime ?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the different normalization forms?
Explain an index segment?
What is oracle in java?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
Explain the use of indexes option in imp command.
Why does for update in oracle 8 cause an ora-01002 error?
What are the sql clauses supported in the link property sheet ?
Oracle General 
