After the queries are executed, you'll have result identifiers hanging around the ether, waiting to have their contents extracted and displayed. This next set of functions shows how this is done. Using MySQL, loop through result set. Display results on their own line. Using MS-SQL, loop through result set.
Display results on their own line.
So, in order to tell the function, explicitly, which row you need to fetch, you must first get the total number of rows in the result set, then manually increment through the result set. This example will produce the same 14 lines of text as the MySQL and Microsoft SQL Server example. Now on to the Oracle 8 example, which again puts its own twist on the fetching issue. All of the database connectivity functions are variations on the same theme. Most people will never use all of them, but they're there, and more are added as users contribute their code, knowledge and experiences with existing functions.