Result Set Meaning In Sql. If the result set type is Single row the result name must be the column name or the column position in the column list. A cursor pointer is also maintained in a ResultSet object to identify the current data row.
A ResultSet object maintains a cursor pointing to its current row of data. Surprisingly enough it did. If the result set type is Full result set or XML you must use 0 as the result set name.
3 Using SQL ORDER BY clause to sort values in a numeric column example.
Initially the cursor is positioned before the first row. This section describes what is a ResultSet object. This feature allows us to modify the column names and column data types of the result sets returned by a stored procedure without actually modifying the stored procedure code. First the database system sorts the result set by the first name in ascending order then it sorts the sorted result set by the last name in descending order.