摘要：查询锁住进程 SELECT object_name, machine, s.sid, s.serial# FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id　= o.object_id AND l.sessio 阅读全文

摘要：数据表dc09表中字段bdc147，需要根据,进行字段拆分。 sql: SELECT SUBSTRING_INDEX( SUBSTRING_INDEX( a.bdc147, ',', b.help_topic_id + 1 ), ',',- 1 ) NAME FROM dc09 a JOIN mys 阅读全文