Answer Posted / nazim

select convert(char(12),getdate(),106)

What is varray?

673

---

What is coalesce function?

653

---

Please explain joins in oracle?

647

---

How to run create database statement?

662

---

What do you understand by a database object?

681

---

---

Explain the use of indexes option in imp command.

647

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1742

---

What are operators in oracle?

609

---

Explain what are the uses of rollback segment?

661

---

What is the difference between hot backup and cold backup in oracle?

624

---

What are the different types of partitions in oracle?

582

---

How will you write a query to get a 5th rank student from a table student_report?

1495

---

What is the quickest way to export a table to a flat file?

647

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1706

---

How do I reset a sequence in oracle?

708

---