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
- 3919 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 |
How to create an oracle testing table?
create one table to capture an employee details with a primary key.
Explain coalesce function?
What is the recommended interval at which to run statspack snapshots, and why?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
what's query optimization and without use of IN AND Exist can we get another way data from query
How can I see all tables in oracle?
Are truncate and delete commands same? If so why?
Can a parameter be passed to a cursor?
how to retrive xml data for using sql query?
What is a user role in oracle?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
Oracle General 
