Oracle - The IN clause

oracle

INSERT INTO SRM.ENTITIES_AP_CATEGORY (ENTITIESID,
                                      AP_CATEGORY_ID,
                                      ADDDATE,
                                      PROJECTSID)
   SELECT A.ENTITIESID,
          B.AP_CATEGORY_ID,
          SYSDATE,
          804
     FROM QXPLORE.ENTITIES A, SRM.AP_CATEGORY B
    WHERE     A.ENTITIESID = VARENTITIESID
          AND B.AP_CATEGORY_ID IN (101, 102, 103, 104)
          AND (ENTITIESID, AP_CATEGORY_ID, 804) NOT IN
                 (SELECT ENTITIESID, AP_CATEGORY_ID, PROJECTSID
                    FROM SRM.ENTITIES_AP_CATEGORY
                   WHERE ENTITIESID = VARENTITIESID AND PROJECTSID = 804);
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License