10 2016 档案

摘要:sys用户登录 SELECT b.sid oracleID, b.username 登录Oracle用户名, b.serial#, spid 操作系统ID, paddr, sql_text 正在执行的SQL, b.machine 计算机名 FROM v$process a, v$session b, 阅读全文
posted @ 2016-10-27 11:26 fashflying 阅读(396) 评论(0) 推荐(0)
摘要:declare cursor readflow_cur is select * from od_readflow t where t.flowid is null; l_emp od_readflow%rowtype; begin open readflow_cur; loop fetch readflow_cur into l_emp; ex... 阅读全文
posted @ 2016-10-11 17:01 fashflying 阅读(223) 评论(0) 推荐(0)