James Hambrick

Technology, Programming, and More

Navigation Menu

Show results from a SQL Union in order by a specific select statement

Posted by on Dec 11, 2014 | 0 comments

I came across an issue at work the other day and I could not find much help on how to accomplish it. So again I want to share it here for others to see. I needed to union a few SQL statements together. Oracle sorting the results by the first field was not helpful. , I wanted the results sorted in order of specific SQL statements. The solution I found that...

Read More

Oracle Greatest Function

Posted by on Nov 25, 2014 | 0 comments

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 that I needed to find the max value between two columns in Oracle. Here is an example...

Read More

Inner Join vs Outer Join

Inner Join vs Outer Join

Posted by on Feb 8, 2013 | 0 comments

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: Customers CUSTID FNAME LNAME ST_ADDRESS CITY STATE HOME_PHONE EMAIL Table 2: Orders ORDID CUSTID PARTID QUANTITY Table 3: Parts PARTID NAME DESCRIPTION QUANTITY  Inner Join Vs Outer Join Inner...

Read More