SQL Tips and Traps

This website is not designed to teach you how to program in SQL. It assumes that you already have a basic working knowledge of SQL.

This website is inspired by questions and feedback from students in COMP2400 Relational Databases and COMP3420 Databases Systems, and from interested persons in cyberspace.

Feedback and questions are welcome.

All code on this website was run using Oracle8 SQL*Plus in the unix environment of the Department of Computer Science at ANU.

Useful Commands

Code Fragments

• Apostrophes in Movie Titles
• Complete Columns?
• COUNT
• Looking for Love
• Searching for NULL
• Year from SYSDATE

How to ...

• Get characters out of a string
• Get rid of the  Input truncated to <n> characters  message
• GROUP BY ... HAVING
• Insert dates
• Sort output
• Use more than one expression in a WHERE clause
• Use parameters

Running SQL

• Logging In to SQL
• Quitting SQL
• Using files

[Top]