- 博客(4)
- 收藏
- 关注
RSS订阅原创 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
323
转载 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
175
转载 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
117
转载 排序算法-转
// 快速排序 public class QuickSort { public static void quickSort(int [] arr,int left,int right) { int pivot=0; if(left<right) { pivot=partition(arr,left,right); quickS...
2020-04-07 16:19:41
73
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人