Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
Pl/SQL coding help
Create a type (EMP_DATA) to populate the Employee table data.
Create a type (ERR_TABLE) with the following attributes:
ERR_NO NUMBER,
ERR_COLUMN VARCHAR2(50),
ERR_RESULT VARCHAR2(500)
Create a package USER5_PKG1 with two procedures.
EMP_CHECK
COMPARE_DATA
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
Profile Answers by kshasikumar Questions by kshasikumar
Questions by kshasikumar
This Question is not yet answered!
Related Answered Questions
Related Open Questions