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 / 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 |
Post New Answer View All Answers
What is an oracle table?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to update values in a table in oracle?
What is MTTR advisor in Oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to set up autotrace for a user account?
How to use like conditions in oracle?
Are truncate and delete commands same? If so why?
Explain about functional dependency and its relation with table design?
How to update a table row with a record?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Is it possible to split the print reviewer into more than one region ?
What is an oracle user role?
How index is implemented in oracle database?