匿名用户比如：同步employee表里job_id like 'AD_VP’的记录，写成这样是成功的：
MAP pdb1.hr.employees, TARGET orclpdb.user1.employees,filter ( @strfind (job_id,‘AD_VP’) > 0) ;
但同步job_id like ‘AD_VP’ or job_id like ‘AD_PRES’，语法该怎么写？ 尝试几次都报错
根据语法：MAP source_table, TARGET target_table, WHERE (clause);
可以这样
MAP pdb1.hr.employees, TARGET orclpdb.user1.employees, where(job_id like ‘AD_VP’ or job_id like ‘AD_PRES’)
评论
有用 0试下用where
MAP pdb1.hr.employees, TARGET orclpdb.user1.employees,where(@strfind (job_id,‘AD_VP’)>0 and @strfind (job_id,‘AD_PRES’)>0) ;
参考链接：
函数：
https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/strfind.html#GUID-68A15856-4DEC-4CA1-AC83-474B77DDE2F6
map：
https://docs.oracle.com/goldengate/c1230/gg-winux/GWURF/table-map.htm#GUID-C2356234-3780-48EE-9E7A-F21DC352638C__I2016740
评论 有用 0
墨值悬赏