James Hambrick

Technology, Programming, and More

Navigation Menu

Oracle Application Express Install

Oracle Application Express Install

Posted by on Jan 27, 2013 | 0 comments

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 a free version here. Oracle 11G Express Edition Here you need a login to the Oracle site. If you don’t have one don’t worry, it’s free to create one! Accept the...

Read More

Oracle Named Loops

Posted by on Jan 24, 2013 | 0 comments

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>> before the LOOP keyword, then add LOOP_NAME at the end of the END LOOP keyword as shown below <<MAIN_LOOP>> LOOP ...... END LOOP MAIN_LOOP;   Example using...

Read More

Oracle Sequence Nextval

Posted by on Jan 22, 2013 | 0 comments

Using Oracle sequence nextval you can autonumber a column in a table, that column is usually the primary key. This is useful if you want to increment that column with each new record. This way you do not have to know the max of that column before issuing an insert statement. Assuming the sequence is called CUSTOMER_SEQ and you are inserting a record into...

Read More

Oracle 10G Purge Feature

Posted by on Jan 15, 2013 | 0 comments

With the new Oracle 10G purge feature a table is not truly dropped by using the drop table command. It is only renamed and considered inside Oracle’s recycle bin. This is important to know for 2 reasons. 1. If you drop a table it still counts against your tablespace until you remove it from the recycle bin. 2. If you change your mind about dropping a...

Read More


Posted by on Jan 11, 2013 | 0 comments

With this blog I plan to share my trials and tribulations with my continued learning of various programming languages, I will share my projects with everyone and also share any new findings I come across. I also plan to post about PL/SQL, Oracle Apex, Java and .Net to help people learn about these technologies.  You will also find on this webpage my...

Read More