Oracle APEX Page for File Upload & Download From Directory Instead of Table
File Upload & Download from Directory Instead of Table 1) create table testt1 ( DOCNO number FILE_NAME varchar2(250), FILE_MIMETYPE varchar2(250), FILE_CHARSET varchar2(250) ) 2) Conn as sys User Sql> create or replace directory TEST as 'C:\Test'; Sql> Grant read,write on directory to <user> 3) create or replace view v_testt1 as ( select DOCNO, FILE_NAME, FILE_MIMETYPE, FILE_CHARSET, TO_BLOB((select BFILENAME('TEST', File_Name ) from dual )) DOCIMG , sys.dbms_lob.getlength( BFILENAME('TEST', case when FILE_MIMETYPE is not null then File_Name end)) Download from testt1 ...