Answer / siddharthapenchala

It is used to undo the work performed by the current transaction.

What is where clause in oracle?

0 Answers  

---

What is different bet native dynamic sql and Dbms_Sql?

4 Answers   Thermotech,

---

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  

---

I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.

4 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

Difference between an implicit & an explicit cursor.?

2 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

Explain the use of indexes option in imp command.

0 Answers  

---

What is an oracle recycle bin?

0 Answers  

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

How many types of synonyms in Oracle?

0 Answers   MCN Solutions,

---