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
- 5040 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 to open a cursor variable?
What is a user role in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
List the parts of a database trigger.
material view and view disadvantages?
How to define a variable to match a table column data type?
What is bulk load in oracle?
How many types of segments in Oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is oracle latest version?
How to define an anonymous procedure without variables?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain about achiever in sql?
