What is cursor and where do you use them?
Answers were Sorted based on User's Feedback
Cursor is an named private area called active set which is
used to process the multiple rows returned by the query....
cursors are mainly used in procedure/package/function when
the select qurey in procedure/package/function returns
more than one value....
if their is any issue mail me @
rajesh_natesh@yahoo.com,rajesh.natesh@cognizant.com
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / guest
cursor is temperory block of memory which holds the data as
temperory in buffer
Is This Answer Correct ? | 1 Yes | 3 No |
What is normalisation and its type?
What are the package used in DBMS ?
Explain the types of database normalization?
How do you backup a database?
What is database in simple language?
How do you organize a database?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
Describe the Process of ETL (Extract, Transform, Load).
What is end users in dbms?
What are the main components of a database in healthcare?
How do databases help businesses?
What is different keys in dbms?