select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET','NLS_LANGUAGE','LANGUAGE','NLS_TERRITORY', 'TERRITORY') name,value from v$nls_parameters WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')
NAME VALUE
------------- ----------------------
LANGUAGE TURKISH
TERRITORY TURKEY
CHARACTER SET WE8ISO8859P9
Etiketler :
Oracle