15. check that the Departments and Employees tables and the EmpDept view are in the Selected list, then click Next.16. On the Generate Options page, ensure that the ALTER Objects option is selected.Select Manual Reconcile, then click Next.19. In the Categories list, expand Database Tier and select Database Files, then select SQL File in the Items list. Click OK.22. In the Code Editor for the EMP_FETCHER package body, write the following code.23.-The log window that displays the output of the get_emp() function in the EMP_FETCHER package is as follows :TUTORIAL – DATABASE DEVELOPMENT USING JDEVELOPER Sameera Avilala ([email protected])1. Create the database connection.2. Name the connection as ‘HRConnection’.3. Enter the host name as oracle.cis.ksu.edu and hit next.4. Click on ‘Test Connection’ to get the Success display.5. Right Click on the applications and click on ‘new application’.6. Select the data model from Web application and move the ‘database’ from available to selected technologies.7. Right click on the model and click on new.8. Click on Offline Database Objects in the database tier and select the database diagram in the right side column.9. A blank HR diagram shows up on the screen.10. Drag and drop the ‘employees’ and ‘departments’ from the applications navigator onto the empty diagram where the following dialog box appears.11. The two tables show on the screen as follows:12. Right click in the ‘employees’ box and go to properties.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.14. The new tables now appear now on the screen as follows:15. check that the Departments and Employees tables and the EmpDept view are in the Selected list, then click Next.16. On the Generate Options page, ensure that the ALTER Objects option is selected.Select Manual Reconcile, then click Next.17. Now click Finish so thar the DDL script is generated.18. The DDL script is generated as follows:19. In the Categories list, expand Database Tier and select Database Files, then select SQL File in the Items list. Click OK.20. Copy paste the given code onto the code editor as follows:21. The connections navigator now looks like follows. Right click on packages and selectNew PL/SQL pakage.22. In the Code Editor for the EMP_FETCHER package body, write the following code.23.-The log window that displays the output of the get_emp() function in the EMP_FETCHER package is as follows
View Full Document