| i need one program urgently [message #301312] |
Wed, 20 February 2008 00:46  |
sweethshasi
Messages: 3
Registered: February 2008
|
Junior Member |
|
|
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
Please use the table scott.emp
|
|
|
|
|
|
|
|
|
|
|
|
| Re: i need one program urgently [message #301394 is a reply to message #301381] |
Wed, 20 February 2008 07:49  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| sweethshasi wrote on Wed, 20 February 2008 13:48 | i tried but i am not understand the question. please help me.its very urgent
|
You should have started your homework last week. Then you would not be in such a hurry.
Apparently, you still did not read the Forum rules (as it states quite clearly that you should NOT use indications like 'urgent')
Show us what you tried. Show us where you think you failed.
If you do not understand the question, go ask your teacher.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
