Answer Posted / ramdeep garg

A cursor is a SELECT statement that is defined within the
declaration section of your PLSQL code. We'll take a look
at three different syntaxes for cursors.

Cursor without parameters (simplest)
The basic syntax for a cursor without parameters is:

CURSOR cursor_name
IS
SELECT_statement;



For example, you could define a cursor called c1 as below.

CURSOR c1
IS
SELECT course_number
from courses_tbl
where course_name = name_in;

The result set of this cursor is all course_numbers whose
course_name matches the variable called name_in.



Below is a function that uses this cursor.

CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
RETURN number
IS
cnumber number;

CURSOR c1
IS
SELECT course_number
from courses_tbl
where course_name = name_in;

BEGIN

open c1;
fetch c1 into cnumber;

if c1%notfound then
cnumber := 9999;
end if;

close c1;

RETURN cnumber;

END;

How to delete all rows a table in oracle?

1016

---

How to name query output columns in oracle?

1141

---

What is data block in Oracle?

1058

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

---

What is the difference between translate and replace?

1015

---

How to loop through a cursor variable?

1027

---

Explain the use of ignore option in imp command.

983

---

 What are the oracle DML commands possible through an update strategy?

1009

---

How does oracle handle read consistency?

1054

---

What would you do with an in-doubt distributed transaction?

1924

---

Does oracle charge for java?

1015

---

How to Truncate Table in Oracle

1104

---

Can we connect to ORACLE db using Windows Authentication?

1191

---

Is oracle a language?

903

---

Is there a function to split a string in plsql?

991

---