xutao_ccu的博客

/*根据LS_DELETE_device_0323 的 device_id 更新device的name为LS_DELETE_device_0323 的port_name*/update device de   set de.name =       (select ls.port_name          from LS_DELETE_device_0323 ls         w...

select * from res_spec rs where rs.name like ('%ODF%');201502 OBD201201 ODF201202 光交--OBD总数select (select aa.name from area aa where aa.area_id = de.local_net_id), count(de.device_id) ...

select count(*),cc.connector_id  from connector cc, device de where de.device_id = cc.device_id(+)   and de.status = 'U'   and cc.maint_sts = 'N'   and de.res_spec_id = 201502   group by cc.conn...