GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  PL/SQL
Go To First  |  Previous Question  |  Next Question 
 PL/SQL  |  Question 130 of 155    Print  
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



  
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!


 Related Questions

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 
View Question | Asked by : kshasikumar


 Sponsored Links

 
Related Articles

Core Java Coding Features in JDeveloper

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
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape