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
- 3868 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 |
Which database is better for os platform dependency?
How do I start tns listener?
What is oracle join syntax?
What is ASM (Automatic Storage Management) in Oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to view the dropped tables in your recycle bin?
What do you mean by redo log file mirroring?
What is autonomous transaction?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is the difference between alert log file and tarce file ?
What is a nested table?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
Oracle General 
