March 12, 2008
This article shows how to generate Matrix reports. Matrix reports are also know as "Crosstab" reports.
March 3, 2008
Date arithmetic is widely used in many database applications. This article is about how to add Day, Hour, Minute, Second to a Date value in Oracle.
February 25, 2008
Simplest but most comprehensive hands-on tutorial for SQL learning.
January 31, 2008
Duplicate records can be deleted. Duplicate records can be prevented using Unique Indexes.
October 25, 2007
Once you retrieve your data, you should think about how you would like to view it. You can do a lot of formatting in Oracle SQL, which translates into saved time for you.
September 20, 2007
Start writting Oracle SQL queries right away using the following keywords: SELECT, FROM, WHERE, GROUP BY, HAVING, and ORDER BY. When you write a query, please remember to use...
February 22, 2007
A database organizes data so that it can be easily accessed, altered, and managed. Like virtually all database software, MySQL uses Sstructured Query Language (SQL-pronounced...
October 2, 2006
Both Microsoft Access and MySQL have found wide use in many companies though for different reasons. The main advantage of Access is its relative ease of use while MySQL's strength...
October 1, 2006
MySQL (pronounced My-Ess-Cue-Ell) is a powerful open source relational database management system that uses SQL. This means that MySQL stores data in tables rather than in one...
August 7, 2003
How to backup a remote database directly to the local machine.My company had a server with a nearly-full hard disk. I needed to backup the database but didn't have enough disk...
July 23, 2003
A solution to the error message Microsoft access cannot start because there is no license for it on this machine.I have seen this error arise a few times now. It often occurs...
February 7, 2003
How to use ADO connection string dialog in your applicationUdocumented, can be found in ADODB.
NewConnectionString := PromptDataSource (0, CurrentConnectString);
NewConnectionString...
February 6, 2003
How to backup another PC to the local machine.The following GBAK command will backup a database on another server to the local machine.
GBAK -B -user SYSDBA -password masterkey...
September 26, 2001
A complicated SQL query I had to work out to tell me information about the current database.This query will tell you
TableName, FieldName, FieldType, FieldSubType, ForeignTableName,...
