A Quick Guide to Using SQL and PLSQL in Oracle APEX.pdf - A Quick Guide to Using SQL Within Oracle APEX Oracle APEX is an Oracle application development

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

This preview shows page 1 - 4 out of 15 pages.

© 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:
Image of page 1
© 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.
Image of page 2
© 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.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 15 pages?

  • Spring '19
  • Jan Smith
  • MYSQL , Oracle Corporation, Web browser, Microsoft SQL Server

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture