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
- 3847 Views
- I also Faced
- E-Mail Answers
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 do I uninstall oracle 11g?
What is the disadvantage of User defind function?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is bind variable in oracle 11g?
Oracle
How to store only time; not date and time?
What are the limitations oracle database 10g xe?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to drop a stored function?
How many anonymous blocks can be defined?
How to drop an existing view in oracle?
Can we call procedure inside function in oracle?
How do you find current date and time in oracle?
How to define a data field as not null?
What is a synonym? What are its various types?
