幽靈齋

[code="java"]insert into hr_employe select * from HR_EMPLOYE as of timestamp to_TImeSTamp(sysdate-1) t where not exists (select 1 from Hr_Employe h where t.empid = h.empid )[/code] [code="java"] ...

connect by 是结构化查询中用到的，其基本语法是： 　　select ... from tablename start with 条件1 　　connect by 条件2 　　where 条件3; 　　例： 　　select * from table 　　start with org_id = '123' 　　connect by prior org_id = par...