需求:
根据orgcode查询对应的数据
单个orgcode的查询方式
方式一:
SELECT * FROM WXAQ.T_ANNUAL_INSPECT_ACTUAL A WHERE1=1and(A.INSPECTED_UNITS like '%,010511,%'or A.INSPECTED_UNITS like '010511,%'or A.INSPECTED_UNITS like '%,010511'or A.INSPECTED_UNITS = '010511')
方式二:
SELECT * FROM WXAQ.T_ANNUAL_INSPECT_ACTUAL A WHERE1=1and ',' || A.INSPECTED_UNITS || ',' like '%' || ',' || '010511' || ',' || '%'