Oracle数据库语法系列之【DML】常用汇总
锁住当前用户 | alter user userName account lock; |
解锁当前用户 | alter user userName account unlock; |
更改用户密码 | alter user userName identified by newPassword; |
用户密码失效 | alter user userName password expire; |
更改参考用户(切换) | alter session set current_schema = ‘userName’ |
更改当前会话日期格式 | alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; |
更改当前会话语言格式 | alter session set nls_language='simplified chinese'; [v$nls_valid_values] |
杀掉进程方式1(延迟) | alter system kill session [v$session].'sid,serial#' |
杀掉进程方式2(推荐) | alter system disconnect session 'sid,serial#' post_transaction / immediate; |
杀掉进程方式3(风险) | kill -9 spid (linux) 或 orakill oracle_sid spid (windows) [v$process].spid |
声明:以上教程为博主原创,若需转载请注明出处,谢谢。