Hi All,
I've the following two tables:
create table jobs(
job_id number,
job_code varchar2(20));
insert into jobs values(1, 'Admin');
insert into jobs values(2, 'Operator');
insert into jobs values(3, 'Developer');
insert into jobs values(4, 'Tester');
insert into jobs values(5, 'Designer');
create table emps(
emp_id number,
job_codes varchar2(20));
insert into emps values(10, '1:3:4');
insert into emps values(20, '2:5');
insert into emps values(30, '3:4:5:1');
commit;
Query - Display the employee code and the job_codes they have in their profile.
Thanx.