摘要: 删除序列select 'drop sequence ' || sequence_owner || '.' || SEQUENCE_NAME || ';'from dba_sequenceswhere sequence_owner IN ('AMS', 'AIS') 序列当前值 select 'cre 阅读全文
posted @ 2019-04-04 13:47 钱若梨花落 阅读(780) 评论(0) 推荐(0) 编辑
摘要: SELECT SS.USERNAME, SS.SID, SS.SERIAL#, SS.MACHINE, SS.PROGRAM, SL.OPNAME, SL.TARGET, SL.START_TIME, ROUND(SL.SOFAR * 100 / SL.TOTALWORK, 0) || '%' AS 阅读全文
posted @ 2019-04-04 13:38 钱若梨花落 阅读(2072) 评论(0) 推荐(0) 编辑