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
- 6794 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain an index segment?
What are the differences between char and varchar2 in oracle?
What do you mean by redo log file mirroring?
What is Java Pool in Oracle?
How to create a testing table in oracle?
How do I spool to a csv formatted file using sqlplus?
How to create tables for odbc connection testing?
Difference between the “verify” and “feedback” command?
How to use attributes of the implicit cursor in oracle?
How to delete all rows a table in oracle?
Explain the truncate in oracle?
Is there any function in oracle similar like group_concat of mysql?
What happens if you use a wrong connect identifier?
How to list all user accounts in oracle?
