Sql Name Result Set. If you need to change the column names and their data types after executing a stored then you can execute the stored procedure using WITH RESULT SETS feature. NamedNativeQuery name FridayEmployees query SELECT employeeId FROM schedule_days WHERE dayOfWeek FRIDAY resultSetMapping FridayEmployeeResult.
NamedNativeQuery name FridayEmployees query SELECT employeeId FROM schedule_days WHERE dayOfWeek FRIDAY resultSetMapping FridayEmployeeResult. This SQL command must be invoked dynamically to use the REFTABLENAME variable. If you need to change the column names and their data types after executing a stored then you can execute the stored procedure using WITH RESULT SETS feature.
Number of result sets number of columns column name nullability and data type.
OFF Disable result set caching for the current client session. If you need to change the column names and their data types after executing a stored then you can execute the stored procedure using WITH RESULT SETS feature. A JDBC ResultSet contains records. Number of result sets number of columns column name nullability and data type.