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
- 3920 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
What is the difference between hot backup and cold backup in oracle?
How to create a new user account in oracle?
How to display employee records who gets more salary than the average salary in the department?
Explain what does a control file contain?
What are the different types of record groups in oracle? Explain each of them
What is a private synonym?
How to use "for" statements in oracle?
What is a nested table?
How to insert a new row into a table in oracle?
Whats the benefit of dbms_stats over analyze?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to filter out duplications in the returning rows using oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to use "startup" command to start default instance?
