Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4923 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
How do I limit the number of oracle database connections generated by weblogic server?
How to empty your oracle recycle bin?
State the various uses of dbcc command?
What is a proxy class?
What privilege is needed for a user to create indexes in oracle?
How does the on-delete-cascade statement work?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to define an explicit cursor in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How do I connect to oracle database?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Whether any commands are used for months calculation? If so, what are they?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
