Demo Application

Welcome, APEX_PUBLIC_USER! The purpose of this application is to demonstrate the various techniques used in APEX applications. Please feel free to explore its pages.

The regions on this page illustrate ways that static content regions get used. Most regions format their content using HTML tags such as <a>, <img>, and <table>. This region does not.

Data Restoration

Click the Restore Data link in the navigation bar to restore the tables to their original states.

This link is not discussed in the book. But it is very useful for being able to undo any changes you (or others) make to the database.

Sample Database

DEPT(DeptNo, DName, Loc)

EMP( EmpNo, EName, Job, Mgr, HireDate,
Sal, Comm, DeptNo, Offsite)

  • The underlined fields DeptNo and EmpNo are keys.
  • The italicized field DeptNo is a foreign key of DEPT.

References

Quick Link


Employees