PL SQL开发
文章平均质量分 59
翘楚时代
翘楚时代
展开
-
PL SQL 多表关联更新
UPDATE TABLE1 T1 SET T1.USERTIME = (SELECT T2.USERTIME FROM TABLE2 T2 WHERE T2.MSGID_DB = T1.MSGID) WHERE EXISTS (SELECT 1 FROM TABLE2 T2 WHERE T2.MSGID_DB = T1.MSGID); --更新多个字段: UPDAT原创 2013-08-13 13:56:48 · 1846 阅读 · 0 评论 -
oracle start with connect by 用法
Oracle中start with...connect by prior子句用法 connect by 是结构化查询中用到的,其基本语法是: select ... from tablename start with 条件1 connect by 条件2 where 条件3; 例: select * from table start with org_id = 'HB原创 2013-11-26 08:30:39 · 1286 阅读 · 0 评论