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
- 6841 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
Please explain drop constraint oracle?
What is meant by an index?
How to put more than 1000 values into an oracle in clause?
How to create an initialization parameter file?
How to create a table interactively?
What happens if you use a wrong connect identifier?
How to rename an existing table?
How data locks are respected in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to update values in a table in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is the use of file param in imp command?
What is ASM (Automatic Storage Management) in Oracle?
Explain the use of rows option in imp command.
What is Reduced List of Values?
