Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are the set operators union, union all, minus & intersect meant to do?
What is the meaning of recursive hints in oracle?
Differentiate between post-database commit and post-form commit?
What privilege is needed for a user to query tables in another schema?
What happens if the imported table already exists?
Explain what are the uses of rollback segment?
What are the general rules on data consistency?
Why cursor variables are easier to use than cursors?
what's query optimization and without use of IN AND Exist can we get another way data from query
What are the differences between blob and clob in oracle?
How to use group functions in the select clause using oracle?
How to convert character types to numeric types?
How to write a query with an inner join in oracle?
How to delete all rows a table in oracle?
State any two functions of oracle?
