select clientnumber,ordate,shipping date from order where months

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.

Question Posted / subhajit acharyya

3 Answers
6800 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many categories of data types?

977

Explain view?

1013

How does the on-delete-cascade statement work?

1088

Is oracle a programming language?

971

Explain the types of exception?

1123

What are a query and state the different types of queries and their uses?

999

How many data types are supported?

1068

What is a server parameter file in oracle?

1035

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1850

What are the uses of a database trigger?

976

How do I manually create a database in oracle?

1000

Why does for update in oracle 8 cause an ora-01002 error?

983

What is Trigger in Oracle?

1136

What is a lookup table in oracle?

963

How to change program global area (pga) in oracle?

1070