Send Oracle Database Queries With Java
Using the OracleDatabaseController to process a database query using ResultSet and ResultSetMetaData to a String.
Table of Contents:
00:13 - The connectToOracle method
01:06 - Imports needed
01:23 - The resultSetToString method
02:46 - Validate query execution
02:59 - Generate the ResultSet
03:22 - The metadata as headers
03:33 - Indices in database land are different!!
04:45 - Add a divider
04:54 - Process the ResultSet
05:20 - Remember database indices are special
06:04 - Check for the last record
06:49 - The demoSimpleQueryAsString
06:53 - Note the lack of a semicolon!
07:29 - Display results
07:39 - Complex query
07:44 - The demoComplexQueryAsString method
08:03 - Use extra spaces and indentation!
08:34 - Display Complex Results