随笔分类 -  ORACLE

摘要：定时执行脚本使用SPOON 工具建立好转换文件 .ktr，创建下面的.BAT文件，用操作系统的任务调用批处理。G:\soft\data-integration\pan.bat /norep -file=G:\soft\ERPCSN.ktr>>G:\ERPCSN.log 阅读全文

摘要：MERGE INTO tt_secu_orgs p USING (select id, level as c_level , substr(sys_connect_by_path(id,'-')||'-',2) nest_path from tt_secu_orgs start with id = 1 connect by nocycle prior id = parent_id) np ON (p.id = np.id) WHEN MATCHED THEN UPDATE SET p.current_level = np.c_level, p.org_str = 阅读全文