Answer Posted / b.chandan kumar patra

this function returns a single row,based on group of rows.
this function an apperars in select list and having clause
only,
the aggregate functions are
sum(),avg(),min(),max(),count()etc.

How can we force the database to use the user specified rollback segment?

562

---

How to create an initialization parameter file?

545

---

Explain table?

657

---

What is a nested table and how is it different from a normal table?

585

---

What are the different types of database objects?

532

---

---

How can I see all tables in oracle?

547

---

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

566

---

How to rename a tablespace in oracle?

623

---

How do I find the database name in oracle?

603

---

if you ctreate table identity

1849

---

What is transport network substrate (tns) in oracle?

592

---

What is rich query?

544

---

What is a proxy object?

583

---

What is tns name?

547

---

What are triggers in oracle?

565

---