摘要：安装时采用什么字符集主要看你的需求，一般测试用的话，就用UTF8.后面可以修改，10g：UTF8 到ZHS16GBKSHUTDOWN IMMEDIATE; STARTUP MOUNT ; ALTER SYSTEM ENABLE RESTRICTED SESSION;ALTER SYSTEM SET ... 阅读全文

摘要：select saddr,sid,serial#,paddr,username,status from v$session where username is not null;alter system kill session'195,169';drop user emis cascade;sql... 阅读全文

摘要：select sfzh,WMSYS.WM_CONCAT(dwmc) dwmc from tb_yggzb group by sfzh order by sfzh 版本为12c见：https://www.cnblogs.com/mingjing/p/8980059.html 阅读全文