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...
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...
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...
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.
November 28, 2000
This article demonstrates how to attach / detatch a database using SQL commands
Open the query analyzer, and enter either
To detatch the database sp_detach_db StuckIndoors
...
April 18, 2005
Selecting data using the Oracle Data Provider for .NET (ODP.NET) is quite simple, however, if you forget a simple step, you may end up selecting blank fields for your LONG or...
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...