Select * from V$NLS_PARAMETERS where PARAMETER='NLS_CHARACTERSET'; Select USERENV('LANGUAGE') from DUAL;