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.
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
What is key preserved table?
Does oracle database need java?
How to name query output columns in oracle?
Explain the use of inctype option in exp command.
What's dateware house and what's clustor with practicle example
 What are the oracle DML commands possible through an update strategy?
What is BBED in Oracle?
How to estimate disk space needed for an export job?
Please explain joins in oracle?
What is raw datatype?
What is a sub query? Describe its types?
How to call a stored function with parameters?
State and explain the different types of data models?
What is a schema in oracle?
Why do you use stored procedures and state some of its disadvantages?