PHILIP DUHE'S BLOG

The Savepoint statement is useful when you want to identify a transaction point to roll back to. This could be a situation where you are u...

This post reviews several ways to write Oracle SQL to reflect a hierarchical structure in an organization. The caveat here is that the table...

There are many different ways to solve a SQL problem. As requests for database information become more complex, the need for added programm...

The Union Join statement is a powerful join in SQL. The Union Join is not to be confused with the Union set operator. The Union Join enabl...

As a SQL programmer, if you need to calculate subtotals and a grand total in a query, the SLQ ROLLUP function fits the bill. The ROLLUP fun...

This post shows INTERSECT and MINUS operators that make nice additions to your SQL toolkit. First let's establish the tables we'll ...

The PHP Data Objects(PDO) extension provides a consistent object-oriented interface for using PHP to access databases and execute SQL querie...

The Apache Foundation provides an open source tool called XAMPP with modules that include the Apache webserver,PHP, MySQL, a file server cal...

The RAND() function is used for returning random numbers. For example, the statement SELECT rand() will return a random number between 0 an...

Using SQL*Plus is the classic way of creating and managing Oracle databases. It is available with all installations on all operating system...