cur fetchmany([size]returns sequence of result rows ( list of tuplessize is the number of rows to return if omittedthe value of cur arraysize is used as default the actual number of rows returned may be less than requested an empty sequence is returned if no more rows are available cur fetchall(returns sequence of all remaining result rows ( list of tuplescur nextset(discards all remaining rows in the current result set and skips to the next result set (if anyreturns none if there are no more result setsotherwisea true value is returned and subsequent fetch*(operations return data from the new set cur setinputsize(sizesgives the cursor hint about the parameters to be passed on subsequent execute*(methods sizes is sequence of type objects (described shortlyor integers which give the maximum expected string length for each parameter internallythis is used to predefine memory buffers for creating the queries and commands sent to the database using this can speed up subsequent execute*(operations cur setoutputsize(size [column]sets the buffer size for specific column in result sets column is an integer index into the result rowand size is the number of bytes typical use of this method is to set limits on large database columns such as stringsblobsand longs prior to making any execute*(calls if column is omittedit sets limit for all columns in the result cursors have number of attributes that describe the current result set and give information about the cursor itself cur arraysize an integer that gives the default value used for the fetchmany(operation this value may vary between database modules and may be initially set to value that the module considers to be "optimal cur description sequence of tuples that give information about each column in the current result set each tuple has the form (nametype_codedisplay_sizeinternal_sizeprecisionscalenull_okthe first field is always defined and corresponds to the column name the type_code can be used in comparisons involving the type objects described in the "type objectssection the other fields may be set to none if they don' apply to the column cur rowcount the number of rows in the last result produced by one of the execute*(methods if set to - it means that there is either no result set or that the row count can' be determined although not required by the specificationthe cursor object in most database modules also implements the iteration protocol in this casea statement such as for row in curwill iterate over the rows the result set created by the last execute*(method lib fl ff