Getting Started with ADF - Oracle ADF 11gR2 Development Beginner's Guide - page 35

Time for action - setting up the database tables
In order to create the Employee and Department tables for HRSchema , you will have to
download the sample script ( Demobld.sql ) from http://www.oracle-database-
tips.com/demobld.html .
1. In order to run this script, right-click on the HRSchema opion from the IDE
Connecions panel and select Open in Database Navigator as shown in the
following screenshot:
2. This will open the connecion in the Database Navigator panel, and open an SQL
worksheet for you.
3. Copy and paste the SQL statements from Demobld.sql to the worksheet.
4. Click on the Run Script opion available for the worksheet or press F5 .
What just happened?
The demobld.sql script will create the following tables in the HRSchema database:
EMP , DEPT , BONUS , SALGRADE , and DUMMY .
These tables can be located from the Tables secion in HRSchema .
Other tables that you see in HRSchema are the tables that
get created as part of Oracle XE Express Ediion.
Time for action - creating a database connection
To create a connecion for the applicaion, you may follow these steps:
1. Create the connecion for Applicaion Resources as per the previous steps.
2. Click on the + (plus) sign to create a new connecion.