database concepts

Oracle links

This page provides you with a range of resources and information to enable you to use Oracle.

Getting started with Oracle

To begin to use Oracle, please work through the following links:

  1. The Oracle set up that will be used in this unit
  2. Logging on and off Oracle
  3. Changing your password 
  4. Running an SQL statement
  5. Useful tips

 

Useful links

NULLs
NULLs do not behave like any other value. See why in the reading NULLs.

DATEs
Oracle's treatment of dates is different from that of the SQL standard. This is explained in the reading called DATEs.

GRANT and REVOKE
These two commands are used to allow or disallow access to database objects such as tables. To see how to use the commands view GRANT and REVOKE