GeekInterview.com
Series: Subject:
Question: 61 of 196

Pl/SQL coding help

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:

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
Asked by: kshasikumar | Member Since Nov-2006 | Asked on: Feb 20th, 2008

View all questions by kshasikumar

This Question is not yet answered!

Related Open Questions

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

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.