(1)多加一个参数NLS_DATE_LANGUAGE = AMERICAN
select to_date( '01-Oct-2014' ,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') from dual
(2)修改注册表,修改NLS_LANG的值
select to_date( '01-Oct-2014' ,'DD-MON-YYYY','NLS_DATE_LANGUAGE = AMERICAN') from dual
(2)修改注册表,修改NLS_LANG的值