Answer / v.ramesh

Implicit cursor is taken care by oracle server only,when we write any statement or query in the SQL editor,in that case oracle server create some memory for that and do operation on that query and finally erase the space as well

in case of Explicit cursor,manually like we need to create the Cursor and open.fetch the data and close the cursor.

we have one more alternative for this,if we will create cursor we need to user FOR LOOP mechanism in this case all exlicit cursor are not needed i.e OPEN<FETCH<CLOSE

Answer / basanti

IMPLICIT CURSOR: When we execute any sql statement, PL/SQL creates implicit cursor and manages automatically means implcit open & close takes place. It used when sql statement return only one row.
It has 4 attributes SQL%ROWCOUNT, SQL%FOUND, SQL%NOTFOUND, SQL%ISOPEN.

EXPLICIT CURSOR: It is created & managed by the programmer. It needs every time explicit open,fetch & close.
It is used when sql statement returns more than one row.
It has also attributes CUR_NAME%ROWCOUNT, CUR_NAME%FOUND, CUR_NAME%NOTFOUND, CUR_NAME%ISOPEN.

Explain the use of file option in exp command.

0 Answers  

---

What is translate in oracle?

0 Answers  

---

What is the difference between translate and replace?

0 Answers  

---

Does oracle charge for java?

0 Answers  

---

Is it possible to insert comments into sql statements return in the data model editor ?

0 Answers   Oracle,

---

State the difference between a primary key and foreign key?

0 Answers  

---

Use of an integrity constraint is better to validate data. Explain

0 Answers  

---

SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me

6 Answers   TCS,

---

What is a procedure in oracle?

0 Answers  

---

Difference between inner join vs where ?

0 Answers  

---

What is different types of joins?

0 Answers  

---

What is use of oracle?

2 Answers   Satyam,

---