1. Creating Table
CREATE TABLE WEB_IMAGE_TEMP1
(
SRLNO NUMBER,
CUST_ID NUMBER,
CUST_IMG LONG,
MIME_TYPE VARCHAR2(2000 BYTE)
)
2. Create Query To Show Image In Forms (Specially In Oracle Apex. )
Select '<img src="'||Value||'"/>' Image
From (
Select TO_CLOB('data:image/png;base64,')||IMAGE Value
From(
WITH xml AS
(SELECT DBMS_XMLGEN.getxmltype
('select cust_img from MEMIMG.WEB_IMAGE_TEMP1')
AS xml
FROM DUAL)
SELECT EXTRACTVALUE (xs.object_value, '/ROW/CUST_IMG') AS image
FROM xml x
, TABLE (XMLSEQUENCE (EXTRACT (x.xml, '/ROWSET/ROW'))) xs)
)
CREATE TABLE WEB_IMAGE_TEMP1
(
SRLNO NUMBER,
CUST_ID NUMBER,
CUST_IMG LONG,
MIME_TYPE VARCHAR2(2000 BYTE)
)
2. Create Query To Show Image In Forms (Specially In Oracle Apex. )
Select '<img src="'||Value||'"/>' Image
From (
Select TO_CLOB('data:image/png;base64,')||IMAGE Value
From(
WITH xml AS
(SELECT DBMS_XMLGEN.getxmltype
('select cust_img from MEMIMG.WEB_IMAGE_TEMP1')
AS xml
FROM DUAL)
SELECT EXTRACTVALUE (xs.object_value, '/ROW/CUST_IMG') AS image
FROM xml x
, TABLE (XMLSEQUENCE (EXTRACT (x.xml, '/ROWSET/ROW'))) xs)
)
No comments:
Post a Comment