Remove Duplicate Rows from DataTable in C#
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...
Welcome To My Programming Portfolio Website
Design
Recent work More work »
Blog
Recent news More posts »Inner Join vs Outer Join
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
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
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>>...
Oracle Sequence Nextval
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...
Oracle 10G Purge Feature
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...