SQL query to get MIME type for file extension

Oracle SQL query to get MIME type for file extension

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
SELECT :file_extension file_extension,
DECODE (
:file_extension,
'.aac', 'audio/aac',
'.abw', 'application/x-abiword',
'.arc', 'application/octet-stream',
'.avi', 'video/x-msvideo',
'.azw', 'application/vnd.amazon.ebook',
'.bin', 'application/octet-stream',
'.bmp', 'image/bmp',
'.bz', 'application/x-bzip',
'.bz2', 'application/x-bzip2',
'.csh', 'application/x-csh',
'.css', 'text/css',
'.csv', 'text/csv',
'.doc', 'application/msword',
'.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
'.eot', 'application/vnd.ms-fontobject',
'.epub', 'application/epub+zip',
'.es', 'application/ecmascript',
'.gif', 'image/gif',
'.htm', 'text/html',
'.html', 'text/html',
'.ico', 'image/x-icon',
'.ics', 'text/calendar',
'.jar', 'application/java-archive',
'.jpeg', 'image/jpeg',
'.jpg', 'image/jpeg',
'.js', 'application/javascript',
'.json', 'application/json',
'.mid', 'audio/midi audio/x-midi',
'.midi', 'audio/midi audio/x-midi',
'.mpeg', 'video/mpeg',
'.mpkg', 'application/vnd.apple.installer+xml',
'.odp', 'application/vnd.oasis.opendocument.presentation',
'.ods', 'application/vnd.oasis.opendocument.spreadsheet',
'.odt', 'application/vnd.oasis.opendocument.text',
'.oga', 'audio/ogg',
'.ogv', 'video/ogg',
'.ogx', 'application/ogg',
'.otf', 'font/otf',
'.png', 'image/png',
'.pdf', 'application/pdf',
'.ppt', 'application/vnd.ms-powerpoint',
'.pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
'.rar', 'application/x-rar-compressed',
'.rtf', 'application/rtf',
'.sh', 'application/x-sh',
'.svg', 'image/svg+xml',
'.swf', 'application/x-shockwave-flash',
'.tar', 'application/x-tar',
'.tif', 'image/tiff',
'.tiff', 'image/tiff',
'.ts', 'application/typescript',
'.ttf', 'font/ttf',
'.txt', 'text/plain',
'.vsd', 'application/vnd.visio',
'.wav', 'audio/wav',
'.weba', 'audio/webm',
'.webm', 'video/webm',
'.webp', 'image/webp',
'.woff', 'font/woff',
'.woff2', 'font/woff2',
'.xhtml', 'application/xhtml+xml',
'.xls', 'application/vnd.ms-excel',
'.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
'.xml', 'application/xml',
'.xul', 'application/vnd.mozilla.xul+xml',
'.zip', 'application/zip',
'.3gp', 'video/3gpp',
'.3g2', 'video/3gpp2',
'.7z', 'application/x-7z-compressed',
'text/plain') "MIME Type"
FROM DUAL
SELECT :file_extension file_extension, DECODE ( :file_extension, '.aac', 'audio/aac', '.abw', 'application/x-abiword', '.arc', 'application/octet-stream', '.avi', 'video/x-msvideo', '.azw', 'application/vnd.amazon.ebook', '.bin', 'application/octet-stream', '.bmp', 'image/bmp', '.bz', 'application/x-bzip', '.bz2', 'application/x-bzip2', '.csh', 'application/x-csh', '.css', 'text/css', '.csv', 'text/csv', '.doc', 'application/msword', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', '.eot', 'application/vnd.ms-fontobject', '.epub', 'application/epub+zip', '.es', 'application/ecmascript', '.gif', 'image/gif', '.htm', 'text/html', '.html', 'text/html', '.ico', 'image/x-icon', '.ics', 'text/calendar', '.jar', 'application/java-archive', '.jpeg', 'image/jpeg', '.jpg', 'image/jpeg', '.js', 'application/javascript', '.json', 'application/json', '.mid', 'audio/midi audio/x-midi', '.midi', 'audio/midi audio/x-midi', '.mpeg', 'video/mpeg', '.mpkg', 'application/vnd.apple.installer+xml', '.odp', 'application/vnd.oasis.opendocument.presentation', '.ods', 'application/vnd.oasis.opendocument.spreadsheet', '.odt', 'application/vnd.oasis.opendocument.text', '.oga', 'audio/ogg', '.ogv', 'video/ogg', '.ogx', 'application/ogg', '.otf', 'font/otf', '.png', 'image/png', '.pdf', 'application/pdf', '.ppt', 'application/vnd.ms-powerpoint', '.pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', '.rar', 'application/x-rar-compressed', '.rtf', 'application/rtf', '.sh', 'application/x-sh', '.svg', 'image/svg+xml', '.swf', 'application/x-shockwave-flash', '.tar', 'application/x-tar', '.tif', 'image/tiff', '.tiff', 'image/tiff', '.ts', 'application/typescript', '.ttf', 'font/ttf', '.txt', 'text/plain', '.vsd', 'application/vnd.visio', '.wav', 'audio/wav', '.weba', 'audio/webm', '.webm', 'video/webm', '.webp', 'image/webp', '.woff', 'font/woff', '.woff2', 'font/woff2', '.xhtml', 'application/xhtml+xml', '.xls', 'application/vnd.ms-excel', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '.xml', 'application/xml', '.xul', 'application/vnd.mozilla.xul+xml', '.zip', 'application/zip', '.3gp', 'video/3gpp', '.3g2', 'video/3gpp2', '.7z', 'application/x-7z-compressed', 'text/plain') "MIME Type" FROM DUAL
SELECT :file_extension file_extension,
       DECODE (
          :file_extension,
          '.aac', 'audio/aac',
          '.abw', 'application/x-abiword',
          '.arc', 'application/octet-stream',
          '.avi', 'video/x-msvideo',
          '.azw', 'application/vnd.amazon.ebook',
          '.bin', 'application/octet-stream',
          '.bmp', 'image/bmp',
          '.bz', 'application/x-bzip',
          '.bz2', 'application/x-bzip2',
          '.csh', 'application/x-csh',
          '.css', 'text/css',
          '.csv', 'text/csv',
          '.doc', 'application/msword',
          '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
          '.eot', 'application/vnd.ms-fontobject',
          '.epub', 'application/epub+zip',
          '.es', 'application/ecmascript',
          '.gif', 'image/gif',
          '.htm', 'text/html',
          '.html', 'text/html',
          '.ico', 'image/x-icon',
          '.ics', 'text/calendar',
          '.jar', 'application/java-archive',
          '.jpeg', 'image/jpeg',
          '.jpg', 'image/jpeg',
          '.js', 'application/javascript',
          '.json', 'application/json',
          '.mid', 'audio/midi audio/x-midi',
          '.midi', 'audio/midi audio/x-midi',
          '.mpeg', 'video/mpeg',
          '.mpkg', 'application/vnd.apple.installer+xml',
          '.odp', 'application/vnd.oasis.opendocument.presentation',
          '.ods', 'application/vnd.oasis.opendocument.spreadsheet',
          '.odt', 'application/vnd.oasis.opendocument.text',
          '.oga', 'audio/ogg',
          '.ogv', 'video/ogg',
          '.ogx', 'application/ogg',
          '.otf', 'font/otf',
          '.png', 'image/png',
          '.pdf', 'application/pdf',
          '.ppt', 'application/vnd.ms-powerpoint',
          '.pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
          '.rar', 'application/x-rar-compressed',
          '.rtf', 'application/rtf',
          '.sh', 'application/x-sh',
          '.svg', 'image/svg+xml',
          '.swf', 'application/x-shockwave-flash',
          '.tar', 'application/x-tar',
          '.tif', 'image/tiff',
          '.tiff', 'image/tiff',
          '.ts', 'application/typescript',
          '.ttf', 'font/ttf',
          '.txt', 'text/plain',
          '.vsd', 'application/vnd.visio',
          '.wav', 'audio/wav',
          '.weba', 'audio/webm',
          '.webm', 'video/webm',
          '.webp', 'image/webp',
          '.woff', 'font/woff',
          '.woff2', 'font/woff2',
          '.xhtml', 'application/xhtml+xml',
          '.xls', 'application/vnd.ms-excel',
          '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
          '.xml', 'application/xml',
          '.xul', 'application/vnd.mozilla.xul+xml',
          '.zip', 'application/zip',
          '.3gp', 'video/3gpp',
          '.3g2', 'video/3gpp2',
          '.7z', 'application/x-7z-compressed',
          'text/plain')   "MIME Type"
FROM DUAL

For more reusable queries, click https://tech7.in/category/technologyblog/oracle/

Related posts: Upload your own post and refer it anywhere anytime: