1.定制SQLselect cfg.devicename,cfg.targetip,cfg.instname,unix_date_to_oracle(st.timerecorded),st.* from _PATROL__FIL_0_ST_VIEW st,_PATROL__FIL_0_CFG_VIEW cfg where st.moinstidcfg.moinstid and cfg.INSTNAMEroot order by unix_date_to_oracle(st.timerecorded) desc2.结果