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

3. Right-click on EmpDirectoryApplicaion and select New Connecion .
4. Right-click on HRSchema and select Add to Applicaion .
5. Drag HRSchema from IDE Connecions and drop it on EmpDirectoryApplicaion
in the Database Navigator panel.
Have a go hero - run some queries
You have all the required tables created in your database. Now it is ime to do some pracical
exercises to fetch the data. You should use the SQL worksheet to write the query and execute
it accordingly. The following are some exercises to fetch the data:
1. Display all the records in the EMP and DEPT tables
2. Display the name of department number 10
3. Display all the employees having a salary of less than 1000
4. Display all the employees in the sales department
Build business services
The next step is to create business components.
You will have to click on Go to Substeps to list the sub steps involved in creaing the business
components.
Before staring with the creaion of the business components, we will iniialize our Model
project. The Project Properies dialog is accessed by right-clicking on the Model project and
selecing the Project Properies menu opion.
Accessing the project properties
There are two ways to get access to the Project Properies dialog; they are as follows:
1. Select the Model project and click on the Project Properies icon in the Projects panel.
2. Right-click on the Model project and select the Project Properies opion from the
menu as shown in the following screenshot: