Answer Posted / samir kumar sahoo

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

How can we view last record added to a table?

597

---

State the various uses of dbcc command?

544

---

How do I know if oracle is installed on windows?

486

---

How to view the data files in the current database?

592

---

What is a trigger oracle?

561

---

---

Difference between the “verify” and “feedback” command?

769

---

Calculate difference between 2 date / times in oracle sql?

568

---

What happens if recursive calls get out of control?

546

---

Explain the dml?

591

---

How to retrieve data from an explicit cursor?

557

---

What are triggers in oracle?

555

---

Explain the use of full option in exp command.

587

---

Can we store images in oracle database?

545

---

What is raw datatype in oracle?

581

---

What are the differences between date and timestamp in oracle?

549

---