Answer / anil kumar abbireddy

when_timer_expired

Can the query output be sorted by multiple columns in oracle?

1 Answers  

---

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,

---

What is the simplest tool to run commands on oracle servers?

1 Answers  

---

What are the different types of databases?

1 Answers  

---

How to turn on or off recycle bin for the instance?

1 Answers  

---

how do u know the total no of rows in a table?

6 Answers  

---

What is the difference between alert log file and tarce file ?

1 Answers   TCS,

---

How to return top 5 rows in oracle?

1 Answers  

---

what is analyze command ? what kind of statistics does it generate?

2 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

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?

1 Answers  

---

Explain what does a control file contain?

1 Answers  

---