A_Bear_Big的博客

alter table table_name enable row movement; FLASHBACK TABLE table_name TO TIMESTAMP TO_TIMESTAMP(‘2020-07-07 09:00:00’,‘yyyy-mm-dd hh24:mi:ss’);

– 用户解锁方法 alter user 用户名 account unlock; 用户密码错误，有可能是密码过期了 更新密码 alter user 用户名 identified by 密码;

一、创建用户 语法[创建用户]： create user 用户名 identified by 口令[即密码]； 例子： create user test identified by test; 语法[更改用户]: alter user 用户名 identified by 口令[改变的口令]; 例子： alter user test identified by 123456; 二、删除用户 语法：drop user 用户名; 例子：drop user test; 若用户拥有对象，则不能直接删除，否则将返回一个

exp 用户名/密码@地址:1521/orcl owner=(用户) file=‘d:\文件名.dmp’; imp 用户名/密码@localhost:1521/orcl file=‘d:\文件名.dmp’ full=y(导入整个文件);

1.简单更新 merge into A using B on (B.id = A.id) when matched then update set A.val = B.val 2.进阶更新 merge into table1 using (select t.id ,max(t.val) m from B t group by t.id) B on (B.id = A.id) when matched then update set A.val = B.m 3.关联条件更新 merge into A us