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
- 3959 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 |
17. Display the order number and average item cost for each order.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What does COMMIT do ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What WHERE CURRENT OF clause does in a cursor?
How to omit columns with default values in insert statement in oracle?
Can a property clause itself be based on a property clause ?
What is the difference between a primary key & a unique key?
What is a tns file?
how can we store any pdf file in oracle
How to find out what privileges a user currently has in oracle?
Give the advantages and disadvantages of clusters.
Oracle General 
