Answer Posted / abdul qadir

aggregate function operates on multiple rows and gives single output

What is truncate oracle?

527

---

What are data pump export and import modes?

604

---

What is the difference between a user and a schema in oracle?

556

---

Please explain compound trigger in oracle?

594

---

What is Trigger in Oracle?

569

---

---

What is a cursor in oracle?

641

---

What are named parameters?

608

---

How do I reset a sequence in oracle?

588

---

How to define a cusotmer as a supplier in ORACLE R12

1726

---

What happens if the imported table already exists?

545

---

What is a server parameter file in oracle?

586

---

How to retrieve data from an cursor to a record?

559

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

926

---

How will you identify oracle database software release?

521

---

Why is oracle so popular?

558

---