jonheller1
Oracle SQL and PL/SQL fanatic. I wrote the book "Pro Oracle SQL Development" and created the Method5 remote execution program to manage hundreds of databases.
R+L CarriersClive, Iowa
Pinned Repositories
data_dump
PL/SQL procedure that exports results of SQL queries to delimited files on the server. Based on http://www.oracle-developer.net/utilities.php
hist_sql_mon
Historical SQL monitoring for Oracle data warehouses.
SQL_Activity_Chart
Oracle SQL query to display database activity.
method4
Run dynamic SQL in SQL. This package allows queries with an unknown number of select-list items and can solve challenging problems like dynamic pivoting.
method5
Remote execution for Oracle SQL, PL/SQL, and shell scripts, built entirely inside Oracle. Method5 lets you easily run commands quickly and securely on hundreds of databases.
plsql_lexer
A PL/SQL package to solve real-world language problems: tokenizing, splitting, classifying, feedback message, and removing terminators.
space
Source code for Pro Oracle SQL Development (www.apress.com/9781484288672) and the data set used for the examples. SpaceDB is an easy-to-use data set that contains all orbital and suborbital launches, satellites, and related data. It's based on the JSR Launch Vehicle Database.
jonheller1's Repositories
jonheller1/SQL_Activity_Chart
Oracle SQL query to display database activity.
jonheller1/data_dump
PL/SQL procedure that exports results of SQL queries to delimited files on the server. Based on http://www.oracle-developer.net/utilities.php
jonheller1/hist_sql_mon
Historical SQL monitoring for Oracle data warehouses.
jonheller1/dla
An application to encapsulate the data dictionary views that have LONG columns. LONGs are converted to CLOBs in pipelined functions, enabling us to search, copy and manipulate these columns with string functions.
jonheller1/gcatdb
(EXPERIMENTAL - DO NOT USE YET) Oracle schema for the General Catalog of Artificial Space Objects
jonheller1/inserter
(EXPERIMENTAL - DO NOT USE YET) Create Oracle INSERT scripts that are significantly faster and more readable.