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 |
what is the main difference between join and subqurey?
What is form and report?
What is raid? How does it help storage of databases?
What type of database is sql?
Can you have more than one trigger on a table?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
When would you denormalize?
8 Answers MBT, Microsoft, MMU,
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
Is sql a backend language?
can i create trigger on synonym is it possible or not please help me
What is nvarchar in sql?
What are crud methods?