View RSS Feed

Recent Blogs Posts

  1. Result Sets and Cursors

    by , 03-09-2012 at 07:28 PM
    Conditions of a query are satisfied by the result set. Result set is considered to be rows set. A result set can return no. of rows.
    • Zero
    • One
    • Many


    One user might obtain 1 row at one time. This functionality is supported by the cursor.
    Pointer and cursor are same which are present in a file that consists of many rows of the result set. Rows track is maintained by the pointer, which are accessible by the program. All rows top to bottom access is supported by a cursor, ...
    Categories
    SQL