Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Oracle9i offers some great tools to make it easy to view the execution plan and trace information for a SQL statement. Prior to Oracle8i, you had to create a plan table and execute special syntax ...

The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form when you want to create a new table with columns ...

How to Encrypt Credit Card Information in an SQL Database. Credit card information in your business's database is much more secure if you encrypt it. If you store this information as plain text ...