Interested to Buy Any Domain ? << Click Here >> for more details...
10. Display the client number, order date and shipping date
for all orders where the shipping date is between three and
six months after the order date.
- 3 Answers
- 6843 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subhajit acharyya
select clientnumber,ordate,shipping date from order where
months_between(shipping date,ordate) between 3 and 6;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mk
elect clientnumber,ordate,shipping date from order where
datediff(mm,Orderdate,Shipping date) In (3,6);
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the difference between a procedure and a function? What do you understand by those terms?
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to call a stored function in oracle?
How to execute a stored program unit?
How are extents allocated to a segment?
What are the types of trigger in oracle?
How to build data dictionary view an new database?
does Oracle has only one table space?
How do I recompile a procedure in oracle?
What is integrity and what is constraint??Explain with example
Explain the use of log option in exp command.
Oracle General 
