数据库
qq_38732270
这个作者很懒,什么都没留下…
展开
-
oracle中commit之后回滚
//先查询到需要恢复的记录select * from table1 as of timestamp to_timestamp('2020-5-14 15:36:10','yyyy-mm-dd hh24:mi:ss');delete from table1//删除所有数据后重新插入insert into table1 select * from table1 as of timestamp to_timestamp('2020-5-14 15:36:10','yyyy-mm-dd hh24:原创 2020-05-14 15:55:01 · 315 阅读 · 0 评论 -
oracle查询被锁的表及解锁
SELECT l.session_id sid, s.serial#, l.locked_mode, l.oracle_username, l.os_user_name, s.machine, s.terminal, o.object_name, s.logon_time FROM v$lo转载 2020-05-14 10:18:11 · 164 阅读 · 0 评论 -
oracle-存储过程
CREATE OR REPLACE PROCEDURE MYDEMO02 AS name VARCHAR(10); age NUMBER(10);BEGIN name := 'xiaoming';--:=则是对属性进行赋值 age := 18; dbms_output.put_line ( 'name=' || ...转载 2020-04-28 18:00:36 · 110 阅读 · 0 评论