A Quick Guide to Using SQL and PLSQL in Oracle APEX.pdf - A...

© David Nelson, Version 2, 5 th October 2018
A Quick Guide to Using SQL Within Oracle APEX
Oracle APEX is an Oracle application development environment which will allow you to access your
Oracle database from outside of the university network. Note that it has restricted functionality
compared to SQL Developer and some advanced SQL and PL/SQL facilities may not run as expected.
The URL to access Oracle APEX is
It is strongly recommended that you use Google Chrome to access Oracle APEX.
Your Workspace name is your user-id, e.g. cs0xyz
Your username is your user-id followed by ‘_apx’, e.g. cs0xyz_apx
Your password is your student registration number , i.e. the long number on your student card.
You should type these details into the window, and then click the
button.
You will then be presented with the following window once you have successfully logged in:

© David Nelson, Version 2, 5 th October 2018
You will notice that in the top menu bar there are four applications, Application Builder, SQL
Workshop, Team Development and Administration. The one you will be using for entering and running
SQL commands is SQL Workshop. Click this and you will be taken to the next menu.
The list of tables ‘Recently Created Tables’ and ‘Recent SQL Commands’ will vary from user to user.

© David Nelson, Version 2, 5 th October 2018
There are three applications which we will need to use within SQL Workshop:
1. Object Browser – this is where you can view and edit tables, views, stored procedures,
functions, etc.
2. SQL Commands – this is where you can type in and directly run SQL commands.
3. SQL Scripts – this allows you to upload and download .sql script files from your local computer
into/from Oracle APEX.
We will now give a brief discussion of each one.
Object Browser
Selecting ‘Object Browser’ will present the screen below. Notice that the list of tables will vary
depending on the tables that you have created in Oracle.