[HD-OCP17/21-Fundamentals Pg 770, Sec. 25.1.5 - retrieving-multiple-resultsets]

[raphaelzintec]

not explaining in which case you needa use it

" it is possible for a query to return multiple result sets."
how is it possible? no explanation here

if author doesnt find the need to explain something then he can just erase it from the book instead of giving vague explanations, a book is not made to push the reader to search always on google

[admin]

Yes, you are right but in this case it is explained with code. If you were expecting something else, do let us know.

test.png (56.69 KiB) Viewed 1729 times

[admin]

Oh did you mean how to write a query that returns multiple result sets? That's in SQL territory not in Java. Writing SQLs is not the focus of the book. You will not be required to write any query for the exam. You will only be required to know how to use JDBC API to fire them and get result(s).

[raphaelzintec]

thanks for the last tip

by far i understood that this getMoreResults() is used when you make a query of two tables