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   Wipro,

---

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.

0 Answers  

---

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

---

How to create an initialization parameter file?

0 Answers  

---

How to restrict the duplicate records in table valuesets

2 Answers   IBM,

---

What is the use of oracle?

0 Answers  

---

Explain temporal data types in oracle

0 Answers  

---

What are the extensions used by oracle reports?

0 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

0 Answers  

---

what is exact difference between drop and truncate table.

3 Answers  

---

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

Is postgres faster than oracle?

0 Answers  

---