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
- 4031 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 to load a large xml file?
How to delete a user account in oracle?
What is the use of oracle?
Explain enable novalidate constraint.
What is the difference between pre-select and pre-query?
What are the advantages of oracle?
How to store pictures on to the database?
Explain the use of Merge statement in oracle 11g
What is oracle in java?
How to display employee records who gets more salary than the average salary in the department?
Why packages are used in oracle?
What is the difference between truncate & delete command?
What is a dead lock in oracle?
What are the attributes that are found in a cursor?
what is dynamic SGA and static SGA
