![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
starWatch
这个作者很懒,什么都没留下…
展开
-
脚本查询时,生成层级关系[递归查询]
select zb_code,zb_fzb,zb_name,connect_by_isleaf isLeaf,LEVEL from t1 Connect By nocycle Prior zb_code = zb_fzb Start With zb_fzb is null zb_code:字段编码。 zb_fzb:字段编码的父节点编码。 zb_name:名称。 connect_by...原创 2018-08-06 15:10:38 · 405 阅读 · 0 评论 -
EAS 查看执行过的sql
select * from v$sqlarea t where t.LAST_ACTIVE_TIME >= {ts'2019-01-15 16:38:00'} and t.LAST_ACTIVE_TIME <= {ts'2019-01-15 16:40:00'} and PARSING_SCHEMA_NAME = 'HBJTCW' order by t.LAST_ACTIVE...原创 2019-01-15 17:23:40 · 609 阅读 · 1 评论