Oracle Character Set query statement sharing

(1) view character sets (all three are equivalent)
Copy codeThe Code is as follows:
Select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET'
Select * from nls_database_parameters where parameter = 'nls _ CHARACTERSET'
Select * from props $ where name = 'nls _ CHARACTERSET'


(2) view the national character set (all three are equivalent)
Copy codeThe Code is as follows:
Select * from nls_database_parameters where parameter = 'nls _ NCHAR_CHARACTERSET'
Select * from nls_database_parameters where parameter = 'nls _ NCHAR_CHARACTERSET'
Select * from props $ where name = 'nls _ NCHAR_CHARACTERSET'


(3) view the character set of oracle server
Copy codeThe Code is as follows:
Select userenv ('language') from dual


(4) DataFile operations
Copy codeThe Code is as follows:
-- DataFile online
Alter tablespace BSS11 ONLINE
Alter database 'bss _ 03. dbf' ONLINE

-- DataFile offline
Alter tablespace BSS11 OFFLINE -- target object: All datafiles in table space BSS11
Alter database 'bss _ 03. dbf' OFFLINE --- action object: BSS_03.dbf, just a datafile

-- Resize datafile
Alter database datafile 'bss _ 03. dbf' RESIZE 500 M;