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 / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I reset a sequence in oracle?
How to define an anonymous procedure without variables?
How many anonymous blocks can be defined?
How does one get the view definition of fixed views/tables?
What is oracle analytical function?
What are the predefined tablespaces in a database?
How do I uninstall oracle client from windows?
What is the purpose of save points in oracle database?
How to convert character types to numeric types?
What is a nvl function? How can it be used?
What is ordinary table in oracle?
Name the various constraints used in oracle?
What are the oracle built-in data types?
How translate command is different from replace?
What is truncate oracle?