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
- 3058 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 the dynamic sql in oracle?
Explain self joins in oracle?
What suggestions do you have to reduce the network traffic?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain the use of grant option in exp command.
What is a sub query? What are its various types?
Explain the use of online redo log files in oracle.
What are the varoius components of physical database structure of oracle database?
What is a package ? What are the advantages of package ?
What are the system predefined user roles?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Explain alias?
Oracle General 
