Home » Other » Training & Certification » i need one program urgently
i need one program urgently [message #301312] Wed, 20 February 2008 00:46 Go to next message
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 #301315 is a reply to message #301312] Wed, 20 February 2008 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You first need to read and follow OraFAQ Forum Guide.
Correctly repost.

Regards
Michel

[Updated on: Wed, 20 February 2008 00:50]

Report message to a moderator

Re: i need one program urgently [message #301324 is a reply to message #301315] Wed, 20 February 2008 01:12 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Sounds like Homework to me Wink
Re: i need one program urgently [message #301381 is a reply to message #301312] Wed, 20 February 2008 06:48 Go to previous messageGo to next message
sweethshasi
Messages: 3
Registered: February 2008
Junior Member
i tried but i am not understand the question. please help me.its very urgent

[Updated on: Wed, 20 February 2008 06:49]

Report message to a moderator

Re: i need one program urgently [message #301388 is a reply to message #301381] Wed, 20 February 2008 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 20 February 2008 07:49
You first need to read and follow OraFAQ Forum Guide.
Correctly repost.

Regards
Michel

Re: i need one program urgently [message #301394 is a reply to message #301381] Wed, 20 February 2008 07:49 Go to previous message
Frank
Messages: 7880
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.
Previous Topic: Please help me
Next Topic: query
Goto Forum:
  


Current Time: Sat Dec 10 07:22:00 CST 2016

Total time taken to generate the page: 0.20715 seconds