- 博客(4)
- 收藏
- 关注
RSS订阅原创 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
1126
原创 查询正执行的procedure的session
SELECT 'alter system kill session '''||s.sid||','||s.serial#||''';',s.* FROM dba_ddl_locks a,v$session s where a.name = upper('p_procedurename') and a.session_id = s.SID ; alter system kill session '17,2315';
2021-12-23 10:31:45
545
原创 查询删除的数据
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
308
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人