SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Load Image files to oracle tables

User_JOHIRSep 6 2018 — edited Sep 24 2018

Experts,

We are working on Oracle 12.2.0.1.0. There are many image files existed in our system with different extensions Eg: .jpg , .png, .jpeg ...

I would like to write a PL/SQL script to load Image files to Oracle Tables.

Here is the oracle Table structure we have created.

create table images_file
(
PIC_ID          NOT NULL NUMBER,        
PIC_FILE_PATH          VARCHAR2(100), 
PIC_FILE_NAME          VARCHAR2(40),  
PIC_NAME               VARCHAR2(80),  
PIC_NBR                VARCHAR2(25) ,    
X_AXIS              NUMBER,        
Y_AXIS              NUMBER,        
PIC_WIDTH              NUMBER,        
CRTD_DT                 TIMESTAMP(6),  
LAST_UPDATED_DT           TIMESTAMP(6)
);

As this is the new table I didn't create any Indexes and not yet inserted any data. Have gone through the google but didn't get proper ideas. Please suggest PL/SQL script which will take care of loading image files to oracle Tables.

let me know if more information required.

Thanks

Vas

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2018

Added on Sep 6 2018

23 comments

5,335 views