5. Display full details from the ORDER_LINE table where the
item number is (first condition) between 1 and 200 (no > or
< operators) OR the item number is greater than 1000 AND
(second condition) the item cost is not in the list 1000,
2000, 3000 OR the order number is not equal to 1000.
- 3 Answers
- 3843 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from order_line
where ( (itemnum between 1 and 200) or itemnum >100)
and not (cost in (1000,2000,3000) or ordernum = 1000)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain constraining triggers.
How to store only time; not date and time?
What is coalesce function?
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?
Explain the features of oracle?
What privilege is needed for a user to insert rows to tables in another schema?
What is Data Dictionary Cache in Oracle?
What are the predefined tablespaces in a database?
How do I manually create a database in oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to open a cursor variable?
State and explain the different types of data models?
What do you know about normalization? Explain in detail?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Give syntax for SQL and ORACLE joins.
