Result Set Extract Sql. 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. A ResultSet object is a table of data representing a database result set which is usually generated by executing a statement that queries the database.
Then set result set property in general tab to single row. The ResultSet object holds the tabular data returned by the methods that execute the statements which quires the database executeQuery method of the Statement interface in general. The javasqlResultSet interface represents the result set of a database query.
The result set RS returned to the caller consists of rows from 6 through 100 of RS and the cursor in the caller is positioned before the first row of RS.
Articles Related Example Here is an example on the HR schema with a PLSQL - Cursor Variables also known as REF CURSORs. ORACLE supports Oracle Database - Stored Procedure which returns SQL Engine - Result Set. The ResultSet object contains a cursorpointer which points to the current row. Sampleval Id like to append value sample1 to variable.