O'Reilly logo
  • Oleksii Hlushchenko thinks this is interesting:

CREATE OR REPLACE FUNCTION SYS.IS_TABLE_SKIPPED(      TAB_OWNER IN VARCHAR2, TAB_NAME IN VARCHAR2)      RETURN NUMBER      IS      COUNT_MATCH NUMBER := 0;      BEGIN        SELECT COUNT(*) INTO COUNT_MATCH FROM DBA_LOGSTDBY_SKIP S        WHERE STATEMENT_OPT = ’DML’ AND ERROR = ’N’ AND        1 =  CASE            WHEN USE_LIKE = ’Y’ THEN              CASE              WHEN ESC = ’Y’ THEN                CASE                WHEN TAB_OWNER LIKE S.OWNER ESCAPE ESC AND                     TAB_NAME  LIKE S.NAME  ESCAPE ESC THEN 1 ELSE 0                END              WHEN ESC = ’N’ OR ESC IS NULL THEN                   CASE                   WHEN TAB_OWNER LIKE S.OWNER AND                        TAB_NAME  LIKE S.NAME THEN 1 ELSE 0            ...

From

Cover of Oracle Data Guard 11g Handbook

Note

Questions