qq_23266643的博客

select zb_code,zb_fzb,zb_name,connect_by_isleaf isLeaf,LEVELfrom t1 Connect By nocycle Prior zb_code = zb_fzb Start With zb_fzb is nullzb_code：字段编码。 zb_fzb：字段编码的父节点编码。 zb_name：名称。 connect_by...

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...