虚位以待(AD)
虚位以待(AD)
首页 > 数据库 > Oracle数据库 > oracle常用命令(查看oracle字符集)

oracle常用命令(查看oracle字符集)
类别:Oracle数据库   作者:码皇   来源:互联网   点击:

select userenv( language ) from dual; 查看oracle字符集alter user scott account unlock; 解锁select username,lock_date from dba_users where username= scott ; 查看锁定时间

select userenv('language') from dual; 查看oracle字符集

 

alter user scott account unlock; 解锁

 

select username,lock_date from dba_users where username='scott'; 查看锁定时间

 

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id; 查看被锁定的表

相关热词搜索: