Oracle中start with...connect by prior子句用法
connect by 是结构化查询中用到的,其基本语法是: select ... from tablename start with 条件1 connect by 条件2 where 条件3;例:select * from tablestart with org_id = HBHqfWGWPyconnect by prior org_id = parent_id; 简单说来是将
转载
2010-02-23 15:43:00 ·
294 阅读 ·
0 评论