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
- 5032 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / murali
select * from order_line where
itemnum between 1 and 200 or itemnum>100
and
cost not in (1000,2000,3000) or ordernum<>1000
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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.
What is bulk copy or bcp in oracle?
What is the difference between online and offline backups?
How view is different from a table?
What is a nested table and how is it different from a normal table?
What is an external table?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What do you understand by a database object? Can you list a few of them?
What is oracle rowcount?
What is an oracle and why it is used?
What is oracle latest version?
What is the difference between I and G in Oracle?
Explain about the analyze command in oracle?
How to change user password in oracle?
What does sharding mean?
