Сбацал класс для просмотра настроек - во вложении.
Выводит так:
select * from nls_database_parameters
NLS_RDBMS_VERSION = "12.1.0.2.0"
NLS_NCHAR_CONV_EXCP = "FALSE"
NLS_LENGTH_SEMANTICS = "BYTE"
NLS_COMP = "BINARY"
NLS_DUAL_CURRENCY = "$"
NLS_TIMESTAMP_TZ_FORMAT = "DD-MON-RR HH.MI.SSXFF AM TZR"
NLS_TIME_TZ_FORMAT = "HH.MI.SSXFF AM TZR"
NLS_TIMESTAMP_FORMAT = "DD-MON-RR HH.MI.SSXFF AM"
NLS_TIME_FORMAT = "HH.MI.SSXFF AM"
NLS_SORT = "BINARY"
NLS_DATE_LANGUAGE = "AMERICAN"
NLS_DATE_FORMAT = "DD-MON-RR"
NLS_CALENDAR = "GREGORIAN"
NLS_NUMERIC_CHARACTERS = ".,"
NLS_NCHAR_CHARACTERSET = "UTF8"
NLS_CHARACTERSET = "CL8MSWIN1251"
NLS_ISO_CURRENCY = "AMERICA"
NLS_CURRENCY = "$"
NLS_TERRITORY = "AMERICA"
NLS_LANGUAGE = "AMERICAN"
SELECT * FROM nls_session_parameters
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CURRENCY = "$"
NLS_ISO_CURRENCY = "AMERICA"
NLS_NUMERIC_CHARACTERS = ".,"
NLS_CALENDAR = "GREGORIAN"
NLS_DATE_FORMAT = "DD-MON-RR"
NLS_DATE_LANGUAGE = "AMERICAN"
NLS_SORT = "BINARY"
NLS_TIME_FORMAT = "HH.MI.SSXFF AM"
NLS_TIMESTAMP_FORMAT = "DD-MON-RR HH.MI.SSXFF AM"
NLS_TIME_TZ_FORMAT = "HH.MI.SSXFF AM TZR"
NLS_TIMESTAMP_TZ_FORMAT = "DD-MON-RR HH.MI.SSXFF AM TZR"
NLS_DUAL_CURRENCY = "$"
NLS_COMP = "BINARY"
NLS_LENGTH_SEMANTICS = "BYTE"
NLS_NCHAR_CONV_EXCP = "FALSE"
SELECT * FROM nls_instance_parameters
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_SORT = ""
NLS_DATE_LANGUAGE = ""
NLS_DATE_FORMAT = ""
NLS_CURRENCY = ""
NLS_NUMERIC_CHARACTERS = ""
NLS_ISO_CURRENCY = ""
NLS_CALENDAR = ""
NLS_TIME_FORMAT = ""
NLS_TIMESTAMP_FORMAT = ""
NLS_TIME_TZ_FORMAT = ""
NLS_TIMESTAMP_TZ_FORMAT = ""
NLS_DUAL_CURRENCY = ""
NLS_COMP = "BINARY"
NLS_LENGTH_SEMANTICS = "BYTE"
NLS_NCHAR_CONV_EXCP = "FALSE"
Последний раз редактировалось Logger; 22.02.2017 в 15:07.
|