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;

What happens in oracle commit?

1072

---

Explain oracle insert into command?

1152

---

What are advantages of dateset in datastage?

2304

---

What is ASM (Automatic Storage Management) in Oracle?

1240

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1120

---

Whether any commands are used for months calculation? If so, what are they?

1135

---

What privilege is needed for a user to delete rows from tables in another schema?

1130

---

Explain the use of inctype option in exp command.

1079

---

Can we call procedure inside function in oracle?

1144

---

What is a sub query? What are its various types?

1270

---

What are the limitations of check constraint?

1071

---

Can sub procedure/function be called recursively?

1041

---

How to concatenate two text values in oracle?

1151

---

How to write text literals in oracle?

1117

---

What is an Oracle index?

1697

---