TUTORIAL – DATABASE DEVELOPMENT USING JDEVELOPER



TUTORIAL – DATABASE DEVELOPMENT USING JDEVELOPER

Sameera Avilala (sameera@ksu.edu)

1. Create the database connection.

[pic]

2. Name the connection as ‘HRConnection’.

[pic]

3. Enter the host name as oracle.cis.ksu.edu and hit next.

[pic]

4. Click on ‘Test Connection’ to get the Success display.

[pic]

5. Right Click on the applications and click on ‘new application’.

[pic]

6. Select the data model from Web application and move the ‘database’ from available to selected technologies.

[pic]

7. Right click on the model and click on new.

[pic]

8. Click on Offline Database Objects in the database tier and select the database diagram in the right side column.

[pic]

9. A blank HR diagram shows up on the screen.

[pic]

10. Drag and drop the ‘employees’ and ‘departments’ from the applications navigator onto the empty diagram where the following dialog box appears.

[pic]

11. The two tables show on the screen as follows:

[pic]

12. Right click in the ‘employees’ box and go to properties.

[pic]

13. Right click on model and click new. Then Click on offline database objects and then click on ‘View’ in the right hand side column.

[pic]

14. The new tables now appear now on the screen as follows:

[pic]

15. check that the Departments and Employees tables and the EmpDept view are in the Selected list, then click Next.

[pic]

16. On the Generate Options page, ensure that the ALTER Objects option is selected.Select Manual Reconcile, then click Next.

[pic]

17. Now click Finish so thar the DDL script is generated.

[pic]

18. The DDL script is generated as follows:

[pic]

19. In the Categories list, expand Database Tier and select Database Files, then select SQL File in the Items list. Click OK.

[pic]

20. Copy paste the given code onto the code editor as follows:

[pic]

21. The connections navigator now looks like follows. Right click on packages and select New PL/SQL pakage.

[pic]

22. In the Code Editor for the EMP_FETCHER package body, write the following code.

[pic]

23.-The log window that displays the output of the get_emp() function in the EMP_FETCHER package is as follows :

[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download