PHILIP DUHE'S BLOG

Articles covering database management, web programming and development, Windows, tips and tricks.

Saturday, April 17, 2010

Oracle Save Point Statement

›
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...
Friday, March 19, 2010

Hierarchical SQL

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

SQL Subqueries

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

The SQL Union Join

›
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...
Wednesday, March 10, 2010

The SQL ROLLUP Function

›
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...
Tuesday, March 9, 2010

The INTERSECT And MINUS Operators In SQL

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

Connect to MySQL using PHP PDO

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

Restarting MySQL from XAMPP

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

SQL Rand Function

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

The SQL*Plus Buffer

›
Using SQL*Plus is the classic way of creating and managing Oracle databases. It is available with all installations on all operating system...
›
Home
View web version
Powered by Blogger.