Tech Trainings

Query to retrieve Employee Image – Oracle Fusion

May 15, 2023 by admin

SELECT 
 per_name.first_name, 
 per_name.last_Name,
 per_i.image_name ,
 per_i.image,
 per_i.image_id 
FROM PER_IMAGES per_i,
 per_all_people_f per_all,
per_person_names_f_v per_name
where 1=1
and PRIMARY_FLAG= 'Y'
and per_i.person_id = per_all.person_Id 
and per_name.person_id = per_all.person_id 
and per_name.name_type ='GLOBAL' 
AND ROWNUM < 10

Comments |0|