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.
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
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How do I know if oracle is installed on windows?
How to use values from other tables in update statements using oracle?
How to use an explicit cursor without open statements?
What are the benefits of ordbms?
How to invoke the original export import utilities?
Explain do view contain data?
6. Display the client name and order date for all orders using the traditional method.
How to establish administrator authentication to the server?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain constraining triggers.
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
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.
How to define an external table with a text file?