Search This Blog

Tuesday, August 8, 2017

Image show in Oracle Apex 5.1

Example of Image show in Oracle Apex 5.1
select EMPLOYEEID,
       EMPLOYEENAME,
       EMAIL,
       MOBILE,
       DEPARTMENTID,
       JOBID,
       SALARY,
       HIREDATE,
'<img src="'||apex_util.GET_BLOB_FILE_SRC('P8_PICTURE',EMPLOYEEID)
||'" height="100px" width="100px"'
    photo
       from EMPLOYEES

No comments:

Post a Comment

Error From Interactive Grid - Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row locking.

Error: Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row ...