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
- 3846 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 |
What is an Index ? How it is implemented in Oracle Database ?
What are the advantages of oracle?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to run create database statement again?
How to open and close an explicit cursor in oracle?
What is the difference between normal and corelated subqueries?
what is kernel?
How to convert dates to characters in oracle?
How to use windows user to connect to the server?
Is there any function in oracle similar like group_concat of mysql?
How to create a new table by selecting rows from another table?
How many types of tables are there in oracle?
Oracle General 
