James Hambrick

Technology, Programming, and More

Navigation Menu

Welcome To My Programming Portfolio Website


More work »


More posts »

Oracle Greatest Function

Posted on Nov 25 by

I came across an issue the other day at work that I thought I could not solve without PL/SQL. I researched because I wanted to get the result using a SQL statement. My issue was...


Remove Duplicate Rows from DataTable in C#

Posted on Mar 19 by

Remove Duplicate Rows from DataTable in C# While it is best to get distinct values directly from the SQL statement before entering them into a datatable there is an easy way to...


Inner Join vs Outer Join

Posted on Feb 8 by

Here I will show the difference between Inner Joins and Outer Joins hence the title Inner Join vs Outer Join. I have three tables to use for these examples. Table1:...


Oracle Application Express Install

Posted on Jan 27 by

In this post I will discuss the steps needed to install Oracle Application Express 4.2.1. First you need to make sure you have an Oracle DB installed on your computer. You can get...


Oracle Named Loops

Posted on Jan 24 by

When using nested loops in your PL/SQL code it is beneficial to use  Oracle named loops to make the code easier to read. To name a loop you simply add <<LOOP_NAME>>...