- 博客(4)
- 收藏
- 关注
原创 Create BD link
create database link hr_db connect to hrprod identified by "123456" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.)(PORT = 1000)) ) (CONNECT_DATA = (SERVICE_NAME = devdb) ) )';...
2021-12-23 10:36:02
1066
原创 查询正执行的procedure的session
SELECT 'alter system kill session '''||s.sid||','||s.serial#||''';',s.* FROM dba_ddl_locks a,v$session swhere a.name = upper('p_procedurename') and a.session_id = s.SID;alter system kill session '17,2315';
2021-12-23 10:31:45
486
原创 查询删除的数据
select * from ap_invoices_all as of timestamp to_timestamp('2014-08-20 12:20:00','yyyy-mm-dd hh24:mi:ss');
2021-12-23 09:24:09
270
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人