Interested to Buy Any Domain ? << Click Here >> for more details...
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).
- 1 Answers
- 3890 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to pass parameters to procedures in oracle?
What is the usage of save points in oracle database?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Is a rollback possible to any savepoint?
How can you merge two tables in oracle?
What is java oracle used for?
How to delete a user account in oracle?
Explain the use of compress option in exp command.
what is the difference between functional dependecy and multilevel dependency?
What is an oracle wallet?
What is bulk load in oracle?
How to create a testing table in oracle?
Oracle General 
