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;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to change system global area (sga) in oracle?
What is a view and how is it different from a table?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to start a new transaction in oracle?
What is Data Dictionary Cache in Oracle?
How to start your 10g xe server?
What are a cluster and non-cluster index?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is oracle in java?
What is data type in oracle?
How to run create database statement again?
what happened to the global index when I truncate the data in one of the partition?
What is oracle instant client?
what is reindexing?
Differentiate between post-database commit and post-form commit?
