Oracle SQL query to get MIME type for file extension
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:- Register a test concurrent program from backend in Oracle EBS
- Supervisor Hierarchy and Approval Limits in Oracle EBS R12
- Query to find vacation rules in Oracle R12
- View java class source in oracle database
- Load Java source code in oracle database
- Query to find all APIs of Oracle Apps modules
- OAF customizations queries
- Oracle apps list of concurrent programs in a Request Set
- Query to get Organization Hierarchy in Oracle apps
- Oracle apps query to find incompatible programs blocking a concurrent request
- Form function attached to which responsibility and user
- Query to find the responsibility attached to user in oracle apps
- How to enable debug log in Oracle apps EBS
- How to add AME role and responsibility to user
- Oracle form attached to which responsibility
- SQL query to get MIME type for file extension
- Query to get concurrent program and executable details
- Query to get responsibility level profile option values
- Query to validate migration of XML/BI Publisher Template and Data Definition
- Query to get details of XML/BI Publisher Template and Data Definition
- Query to get Site level and Organization level Profile Option Value
- PL-SQL code to reset application user password
- PL-SQL Procedure to send email with attachment
- PL-SQL to delete Concurrent Program and Executable
- Query to get the details of the lock in the database
- PL-SQL code to delete XML/BI Publisher template and Data Definition
- Query to find Form Personalization
- Query to find profile option values
- Query to get details of concurrent program parameters
- PL-SQL Code to find Menu Hierarchy of a responsibility
- Query to find details of Flex value sets
- Query to find concurrent program Responsibility and Request Group
- Concurrent program SQL statement currently running in background
- Query to find scheduled concurrent programs
- Query to kill database session for a concurrent request
- Query to get DFF (Descriptive Flex Field) Details