Release Date: August, 2015

Updates:

Application software: Program that gives computer instructions that provide the user with tools to
accomplish a task.
System software: Programs that interact with the computer hardware.

10

Oracle Application Express User Guide is located in Section 0, Course Resources of the Database
Programming with SQL Course. This document will help you become familiar with how to use Oracle
Application Express and each of its components from an end user's perspective.

11

12

Once you have successfully logged in to APEX, follow the instructions in the "Oracle Application Express
User Guide" to access SQL Commands, from the SQL Workshop.

13

More information on the other components of the SQL Command window can be found in the "Oracle
Application Express User Guide".

14

Syntax: The rules governing the formation of statements in a programming language.

15

The <condition> starts with the word WHERE followed by a <column name> and a Comparison Operator (=,
>, <, etc.) followed by a value or IS NULL, IS NOT NULL.
Subset: a part of a larger group of related things.
Comparison Operator: used in conditions that compare one expression with another expression or value.
The syntax of SELECT statements and operators are discussed in more detail in subsequent lessons.

16

When learning to write SQL statements, it is normal to make mistakes in the beginning. With practice and
experience, you make less mistakes, and are able to rectify errors more easily.

17

Your teacher will show you the tables that have been created in your database schema using the Object
Browser.

18

19

20

21