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!

how to extract and generate mime_type for already inserted files in table

ReemaPuriMay 19 2020 — edited May 20 2020

create table testmime

( file_name varchar2(100),

mime_type varchar2(100));

insert into testmime values ('abc.db',null);

insert into testmime values ('abc.doc',null);

insert into testmime values ('abc.PDF',null);

insert into testmime values ('abc.jpg',null);

insert into testmime values ('abc.msg',null);

insert into testmime values ('abc.PNG',null);

insert into testmime values ('abc.xml',null);

insert into testmime values ('abc.stl',null);

insert into testmime values ('abc.ckd',null);

insert into testmime values ('abc.stp',null);

insert into testmime values ('abc.xlsm',null);

insert into testmime values ('abc.txt',null);

insert into testmime values ('abc.png',null);

insert into testmime values ('abc.pdf',null);

insert into testmime values ('abc.ppt',null);

insert into testmime values ('abc.dxf',null);

insert into testmime values ('abc.tif',null);

insert into testmime values ('abc.docx',null);

insert into testmime values ('abc.pptx',null);

insert into testmime values ('abc.dwg',null);

insert into testmime values ('SHEET1',null);

insert into testmime values ('abc.docm',null);

insert into testmime values ('abc.tiff',null);

insert into testmime values ('abc.xlsx',null);

insert into testmime values ('abc.JPG',null);

insert into testmime values ('abc.sql',null);

insert into testmime values ('abc.zip',null);

insert into testmime values ('abc.xls' ,null);

commit;

How can we generate mime_type for these type in oracle 12c

Any idea anybody

This post has been answered by odie_63 on May 20 2020

Jump to Answer

Added on May 19 2020

2 comments

1,037 views