Exclude File Extension

SELECT
SUBSTR('&FileName', 1, LENGTH('&FileName') - INSTR(REVERSE('&FileName'),'.', 1, 1))
FROM DUAL