Oracle 3
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Oracle 3 as PDF for free.
More details
- Words: 60
- Pages: 1
CREATE OR REPLACE DIRECTORY images AS 'C:\Images'; / DECLARE l_bfile BFILE; l_blob BLOB; BEGIN INSERT INTO HTMLDB_APPLICATION_FILES (name, blob_content) VALUES ( 'receipt1.gif', empty_blob()) RETURN blob_content INTO l_blob; l_bfile := BFILENAME('IMAGES', 'receipt1.gif'); DBMS_LOB.fileopen(l_bfile, Dbms_Lob.File_Readonly); DBMS_LOB.loadfromfile(l_blob, l_bfile, DBMS_LOB.getlength(l_bfile)); DBMS_LOB.fileclose(l_bfile); UPDATE EXPENSEITEM SET EXPRECIMG=(SELECT BLOB_CONTENT FROM HTMLDB_APPLICATION_FILES WHERE name ='receipt1.gif') , EXPRECID=(SELECT FROM HTMLDB_APPLICATION_FILES WHERE name ='receipt1.gif') WHERE EINO=1; COMMIT; END; /
ID
ID
Related Documents
Oracle 3
October 2019 29
Oracle 3
April 2020 8
Oracle Backtrack 3
October 2019 7
Rlu Oracle Resume 3
October 2019 17
Oracle
June 2020 26