User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.
Create a type (EMP_DATA) to populate the Employee table data. Create a type (ERR_TABLE) with the following attributes:
COMPARE_DATA takes EMP_DATA as IN PARAMETER and ERR_TABLE as OUT PARAMETER. The procedure should compare the EMP_DATA with the EMP table. The columns that have different values should be added to the ERR_TABLE.
For example,
Table Data EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7654 MARTIN SALESMAN 7698 20-Feb-81 1250 1400 30 EMP_DATA 7654 MARTIN SALESMAN 7902 20-Feb-81 2000 1800 30
ERR_TABLE 1 JOB Old Value: 7698, New Value: 7902 2 SAL Old Value: 1250 New Value: 2000 3 COMM Old Value: 1400, New Value: 1800
EMP_CHECK should populate the value to the EMP_DATA type and call the COMPARE_DATA and display the results of ERR_TABLE
Total Answers and Comments: 0
Last Update: February 20, 2008 Asked by: kshasikumar
Sponsored Links
No answers are posted for this question yet. Be the first to answer it!
User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate
This tutorial introduces you to some of the new features in the latest release of JDeveloper 10g The latest release of JDeveloper 10g offers a host of new features This tutorial introduces some of those that are of particular interest to the Java developer productivity improvements in the Code Edito
