Oracle小知识集锦
Oracle删除后的恢复
savepoint a;
delete from student ;
rollback to a;
Oracle中修改日期格式
alter session set nls_date_format='yyyy-mm-dd'
Oracle中查询字段为空或不为空的记录
select * from student where birthday is null
select * from student where birthday is not null
删除配置文件
drop profile a [cascade]
alter user xh account unlock:为用户解锁
限制用户登录失败的次数
1.建立配置文件,用户登录失败三次就锁二天,黑体为关键字:
create profile a limit failed_login_attempts 3 password_lock_time 2
2.把这个配置文件运用到用户xh
alter user xh profile a
相关推荐
lklong 2020-11-22
oraclemch 2020-11-06
shilukun 2020-10-10
周嘉笙 2020-11-09
iilegend 2020-10-19
EricRay 2020-10-16
zhuzhufxz 2020-09-16
dataminer 2020-08-17
bfcady 2020-08-16
Hody 2020-08-16
FightFourEggs 2020-08-16
数据库设计 2020-08-16
Seandba 2020-08-16
Omega 2020-08-16
zjyzz 2020-08-16
yanghuatong 2020-08-16
ktyl000 2020-08-16
dbasunny 2020-08-16