- 查询字符集
SELECT USERENV('LANGUAGE') FROM DUAL;
select * from nls_database_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
select * from nls_instance_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
select * from nls_session_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
- 批量重命名表
select 'rename table '||table_name||' to '||table_name||'_HPBAK;' from user_tables where table_name like 'ACCT%';
