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
- 3944 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 formal parameters and actual parameters?
How to assign values to variables?
How to define a variable to match a table column data type?
Explain about your project and its relation to the current job position you are applying to?
What is a synonym? What are its various types?
How to rename an index in oracle?
How to insert multiple rows with one insert statement in oracle?
How to create an oracle database?
What is an oracle user account?
How translate command is different from replace?
What is PL/SQL ?
What is bind variable in oracle 11g?
Why we use bulk collect in oracle?
State some uses of redo log files?
Where are the settings stored for each instance in oracle?
