Scribd
Upload
151 views22 pages

Oracle APEX User Guide Overview

The document discusses an Oracle Application Express user guide that helps users become familiar with how to use Oracle Application Express and its components from an end user's perspective. It instructs users to access SQL commands from the SQL workshop after logging into APEX and provides more information on other SQL command window components found in the user guide. Students are directed to enter an example into APEX to see results output and told that SELECT statement syntax and operators are discussed in subsequent lessons.

Uploaded by

maulidyayunanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
151 views22 pages

Oracle APEX User Guide Overview

The document discusses an Oracle Application Express user guide that helps users become familiar with how to use Oracle Application Express and its components from an end user's perspective. It instructs users to access SQL commands from the SQL workshop after logging into APEX and provides more information on other SQL command window components found in the user guide. Students are directed to enter an example into APEX to see results output and told that SELECT statement syntax and operators are discussed in subsequent lessons.

Uploaded by

maulidyayunanda
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
You are on page 1/ 22

3

4
5
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.

6
7
8
9
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.

Students should enter the above example into APEX to see the results output.

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

You might also like