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

PDF to Text Covert by Oracle Apex

Here are the steps to convert and get the character into a region by Oracle Apex. Step1.  Create a page and Copy-Pest the below code into Pa...