Oracle Stored Procedure Example

Introduction I thought I would put together a quick post with some Oracle stored procedure examples.  I wanted some results to compare when writing similar queries/programs in other languages.  I plan to use the same NFL games data set with MapReduce, R, SparkR and other programs. Prerequisites Need to set up Oracle tables and load... Continue Reading →

Oracle SQL Loader Example – NFL 2016 Games

Oracle SQL Loader (sqlldr.exe) utility provides an efficient way to perform a bulk data load into an Oracle table.  Sqlldr.exe doesn’t record inserts into a transaction log, so performance is improved. The following example was set up to walk through a scenario to load data from a text file into an Oracle database.  The steps... Continue Reading →

Blog at WordPress.com.

Up ↑