You can also use PL/SQL
CreateDirectory "image" as 'e:\';--"image" to bring double quotes, many online without, I test error, and, ' E:\ ' is the server directory, non-local directory. User Authorization required: Grant create any directory to username;Declareb_file bfile; B_lob blob; begin Insert intoTB_SJ (SJBM,SJMC,RKSJ,XGSJ,GSBM,SJDATA,LBBM)Values(1,'Figure 2-1 C1SR sedimentary facies plan of ASA key area', Sysdate,sysdate,2, Empty_blob (),4)returnSjdata intoB_lob;--This table is the b_file built between me:=Bfilename ('Image','The drawings 2-1 the C1SR sedimentary facies plan of the ASA's key area. CDR');--tmp is the directory where the files are created, Filename.jpg is the file name, and the file is converted to the bfile typeDbms_lob.Open(b_file,dbms_lob.file_readonly);--Open B_file as read-onlyDbms_lob.loadfromfile (B_lob,b_file,dbms_lob.getlength (b_file));--convert content from B_file to B_lobDbms_lob.Close(B_file); Commit; End;
Oracle uses the Oracle SQL Developer tool to access binary files such as images in BLOB fields