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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction oracle database administration
- user guide oracle
- oracle java application tutorial
- in this chapter we will introduce the new features in
- oracle streams
- database management syllabus
- intergraph igug review oracle
- using the database configuration assistant dbca to
- oracle creating tables
- database creation assignment
Related searches
- free excel tutorial download pdf
- printable excel tutorial in pdf
- database design tutorial for beginners
- database development for dummies pdf
- python tutorial using pycharm
- unity game development tutorial pdf
- database analyst vs database administrator
- advantages of using database system
- database developer vs database architect
- database engineer vs database administrator
- access database tutorial youtube
- database design tutorial pdf