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
- 4886 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 can you merge two tables in oracle?
What does sharding mean?
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.
How to get the Installed Oracle Version Information ?
What is oracle open database communication (odbc)?
Is the After report trigger fired if the report execution fails ?
What is the oracle implicit cursor?
In which language oracle has been developed?
How can I see all tables in oracle?
Can we use bind variables in oracle stored procedure?
What are joins, explain all types of joins?
Explain implicit cursor.
What are the attributes that are found in a cursor?
Explain the use of rows option in imp command.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
