SQL query to get MIME type for file extension

1SELECT :file_extension file_extension,
2       DECODE (
3          :file_extension,
4          '.aac', 'audio/aac',
5          '.abw', 'application/x-abiword',
6          '.arc', 'application/octet-stream',
7          '.avi', 'video/x-msvideo',
8          '.azw', 'application/vnd.amazon.ebook',
9          '.bin', 'application/octet-stream',
10          '.bmp', 'image/bmp',
11          '.bz', 'application/x-bzip',
12          '.bz2', 'application/x-bzip2',
13          '.csh', 'application/x-csh',
14          '.css', 'text/css',
15          '.csv', 'text/csv',
16          '.doc', 'application/msword',
17          '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
18          '.eot', 'application/vnd.ms-fontobject',
19          '.epub', 'application/epub+zip',
20          '.es', 'application/ecmascript',
21          '.gif', 'image/gif',
22          '.htm', 'text/html',
23          '.html', 'text/html',
24          '.ico', 'image/x-icon',
25          '.ics', 'text/calendar',
26          '.jar', 'application/java-archive',
27          '.jpeg', 'image/jpeg',
28          '.jpg', 'image/jpeg',
29          '.js', 'application/javascript',
30          '.json', 'application/json',
31          '.mid', 'audio/midi audio/x-midi',
32          '.midi', 'audio/midi audio/x-midi',
33          '.mpeg', 'video/mpeg',
34          '.mpkg', 'application/vnd.apple.installer+xml',
35          '.odp', 'application/vnd.oasis.opendocument.presentation',
36          '.ods', 'application/vnd.oasis.opendocument.spreadsheet',
37          '.odt', 'application/vnd.oasis.opendocument.text',
38          '.oga', 'audio/ogg',
39          '.ogv', 'video/ogg',
40          '.ogx', 'application/ogg',
41          '.otf', 'font/otf',
42          '.png', 'image/png',
43          '.pdf', 'application/pdf',
44          '.ppt', 'application/vnd.ms-powerpoint',
45          '.pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
46          '.rar', 'application/x-rar-compressed',
47          '.rtf', 'application/rtf',
48          '.sh', 'application/x-sh',
49          '.svg', 'image/svg+xml',
50          '.swf', 'application/x-shockwave-flash',
51          '.tar', 'application/x-tar',
52          '.tif', 'image/tiff',
53          '.tiff', 'image/tiff',
54          '.ts', 'application/typescript',
55          '.ttf', 'font/ttf',
56          '.txt', 'text/plain',
57          '.vsd', 'application/vnd.visio',
58          '.wav', 'audio/wav',
59          '.weba', 'audio/webm',
60          '.webm', 'video/webm',
61          '.webp', 'image/webp',
62          '.woff', 'font/woff',
63          '.woff2', 'font/woff2',
64          '.xhtml', 'application/xhtml+xml',
65          '.xls', 'application/vnd.ms-excel',
66          '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
67          '.xml', 'application/xml',
68          '.xul', 'application/vnd.mozilla.xul+xml',
69          '.zip', 'application/zip',
70          '.3gp', 'video/3gpp',
71          '.3g2', 'video/3gpp2',
72          '.7z', 'application/x-7z-compressed',
73          'text/plain')   "MIME Type"
74FROM DUAL