Hi All,
I have two tables as below with Master and Detail information stored in them.
The requirement is I want to generate an output or create a view with only single record for each employee using these tables.
Based on the sample data inserted into below tables, I wish to have one record having all the information from master and detail tables.
DB Version: 11.2.0.4.0
-----------------------------------------------------------------------------------------------------------
create table emp_eval(
EVAL_ID NUMBER NOT NULL,
EMPLOYEE_NUMBER VARCHAR2(10 BYTE),
EMPLOYEE_NAME VARCHAR2(100 BYTE),
DESIGNATION VARCHAR2(100 BYTE),
ITEM_DATE DATE,
EMP_SUPERVISOR VARCHAR2(10 BYTE),
EVAL_START_DATE DATE,
EVAL_END_DATE DATE,
EVAL_DUE_DATE DATE,
EVAL_SUBMITTED_DATE DATE,
EVAL_SUBMITTED_BY VARCHAR2(10 BYTE),
EVAL_STATUS VARCHAR2(100 BYTE),
OVERALL_RATING VARCHAR2(100 BYTE),
APPROVAL_STATUS VARCHAR2(100 BYTE),
APPROVED_BY VARCHAR2(100 BYTE),
APPROVED_DATE DATE
);
INSERT INTO emp_eval VALUES(1,'987654','FistName, LastName','Associate','20-MAR-2015','345678','01-JAN-2016','31-DEC-2016','15-JAN-2017','03-JAN-2017','345678','SUBMITTED','VG',NULL, NULL,NULL);
create table emp_eval_details(
EVAL_DETAIL_ID NUMBER NOT NULL,
EVAL_ID NUMBER NOT NULL,
FACTOR_TYPE VARCHAR2(100 BYTE),
FACTOR_RATING VARCHAR2(100 BYTE),
ATTRIBUTE1 VARCHAR2(100 BYTE),
ATTRIBUTE2 VARCHAR2(100 BYTE),
ATTRIBUTE3 VARCHAR2(100 BYTE),
ATTRIBUTE4 VARCHAR2(100 BYTE),
ATTRIBUTE5 VARCHAR2(100 BYTE),
ATTRIBUTE6 VARCHAR2(100 BYTE),
ATTRIBUTE7 VARCHAR2(100 BYTE),
ATTRIBUTE8 VARCHAR2(100 BYTE),
ATTRIBUTE9 VARCHAR2(100 BYTE),
ATTRIBUTE10 VARCHAR2(100 BYTE)
);
INSERT INTO emp_eval_details VALUES (1,1,'PR','VG','E','M',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO emp_eval_details VALUES (2,1,'Knowledge','O','E','M','F','M',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO emp_eval_details VALUES (3,1,'Communication','C','E','M','E','E','E','E',NULL,NULL,NULL,NULL);
INSERT INTO emp_eval_details VALUES (4,1,'Skills','G','E','M','E','M','E','M',NULL,NULL,NULL,NULL);
INSERT INTO emp_eval_details VALUES (5,1,'Quality','VG','E','M','E','M',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO emp_eval_details VALUES (6,1,'Leadership','VG','E','M','M','M','F','E',NULL,NULL,NULL,NULL);
--------------------------------------------------------------------------------------------------------------------------------------
Thanks in advance.
Jana