To find out Date, Time and Characterset format of Oracle server.

To find out Date, Time and Characterset format of Oracle server.

 

 

select * from v$nls_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_CHARACTERSET                                                 UTF8                                                            

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_NCHAR_CHARACTERSET                                           AL16UTF16                                                       

NLS_COMP                                                         BINARY                                                          

NLS_LENGTH_SEMANTICS                                             BYTE                                                            

NLS_NCHAR_CONV_EXCP                                              FALSE