Types of cursors and explanation each of them ?
Answers were Sorted based on User's Feedback
Answer / sohail
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / anusha
Cursor is a private work area .there are
three types if cursors
1.implicit cursor: implicit cursors is create,open and
closed by system automatically.
2.explicit cursor: explicitly user can create,open and close
cursors.
3. ref cursor: Reference cursor is a cursor dynamically (at
Run time) we can pass the column names or table names.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / giri
Cursor is a pointer or handler to context area.there are
three types if cursors
1.implicit cursor: Every SQL statment between begin and end
are implicit cursors.sql%found,sql%notfound,sql%is open,sql%count these are the implicit cursor attributes.
2.explicit cursor:As a name user has to explicitly
create,open and close cursors.%found,%notfound,%is open,%count these are the explicit cursor attributes.
3. ref cursor: Reference cursor is a datatype which holds
the value of a cursor.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / aditya
Ref cursor have two types strong ref cursor and weak ref cursor.
declaring a ref cursor and using it for multiple select statements is a weak cursor.
using a ref cursor as an out parameter to get a result set is a strong ref cursor.
Is This Answer Correct ? | 1 Yes | 0 No |
I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body
What is sql and its types?
What is normalization? How many normalization forms are there?
How many sql are there?
How do you exit in sql?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
Why procedure is used in sql?
What is difference between a PROCEDURE & FUNCTION ?
What is sqlca in powerbuilder?
What is rank function in sql?
How do you create a db file?
What is the file extension for sql database?