Answer Posted / venkat

open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program

What is the use of aggregate functions in oracle?

1021

---

How index is implemented in oracle database?

996

---

What is coalesce function?

1062

---

What privilege is needed for a user to create views in oracle?

1035

---

What are group functions in oracle?

1034

---

How to call a stored function in oracle?

1013

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1678

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1875

---

What happens to the current transaction if the session is ended?

1090

---

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?

1380

---

How to drop a stored procedure in oracle?

1046

---

How to convert csv to table in oracle?

984

---

What are the extensions used by oracle reports?

1031

---

What is connection pooling in oracle?

962

---

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1095

---