Display the order number and the number of months since the
order was shipped for all orders that have been shipped in
the last year (365 days). (Hint: Unshipped orders will have
a null value).
Answer Posted / ankit
Select Order_num, MONTHS_BETWEEN(SYSDATE,Shipped_date) no_of_months from Table where shipped_date is not null and to_date('sysdate','YYYY') = '2012';
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can we store any pdf file in oracle
How to manage transaction isolation level?
What is a subquery in oracle?
How to calculate date and time differences in oracle?
What are the differences between primary key and unique key?
How many types of segments in Oracle?
How to execute the package in oracle?
What is logical backup in oracle?
What is a dead lock in oracle?
How to create a table index in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How to assign a table row to a record variable?
What are the restrictions in a oracle read only transaction?
Can a formula column be obtained through a select statement ?
What is data block in Oracle?