Regular Expressions 101

Community Patterns

123...6

DCL

1

Regular Expression
PCRE2 (PHP >=7.3)

/
ALTER\W.*CLUSTER ALTER\W.*DIMENSION ALTER\W.*EXTERNAL\W.*PROCEDURE ALTER\W.*FULLTEXT\W.*CATALOG ALTER\W.*FULLTEXT\W.*INDEX ALTER\W.*FUNCTION ALTER\W.*INDEX ALTER\W.*INDEXTYPE ALTER\W.*LOGIN ALTER\W.*MATERIALIZED\W.*VIEW ALTER\W.*MATERIALIZED\W.*VIEW\W.*LOG ALTER\W.*METHOD ALTER\W.*NICKNAME ALTER\W.*OPERATOR ALTER\W.*PACKAGE ALTER\W.*PARTITION\W.*FUNCTION ALTER\W.*PARTITION\W.*SCHEME ALTER\W.*PROCECURE ALTER\W.*PROCEDURE ALTER\W.*QUEUE ALTER\W.*REPLICATION\W.*GROUP ALTER\W.*ROUTINE ALTER\W.*SEQUENCE ALTER\W.*SERVER ALTER\W.*SESSION ALTER\W.*TABLE ALTER\W.*TRIGGER ALTER\W.*TYPE ALTER\W.*USER\W.*MAPPING ALTER\W.*VIEW ALTER\W.*XML\W.*SCHEMA\W.*COLLECTION ANALYZE BEGIN\W.*LOGGING BEGIN\W.*QUERY\W.*LOGGING COLLECT\W.*DEMOGRAPHICS COLLECT\W.*STATISTICS COLLMOD COMMENT COMPACT CREATE\W.*ALIAS CREATE\W.*AUTHORIZATION CREATE\W.*CAST CREATE\W.*CLUSTER CREATE\W.*DATABASE CREATE\W.*DEFAULT CREATE\W.*DIMENSION CREATE\W.*DISTINCT\W.*TYPE CREATE\W.*DUPLICATE CREATE\W.*ERROR\W.*TABLE CREATE\W.*EXISTING\W.*TABLE CREATE\W.*EXTERNAL\W.*PROCEDURE CREATE\W.*EXTERNAL\W.*TABLE CREATE\W.*FULLTEXT\W.*CATALOG CREATE\W.*FULLTEXT\W.*INDEX CREATE\W.*FUNCTION CREATE\W.*FUNCTION\W.*MAPPING CREATE\W.*GLOBAL\W.*TEMPORARY\W.*TRACE\W.*TABLE CREATE\W.*HASH\W.*INDEX CREATE\W.*INDEX CREATE\W.*INDEX\W.*EXTENSION CREATE\W.*JOIN\W.*INDEX CREATE\W.*LIBRARY CREATE\W.*LOGIN CREATE\W.*MACRO CREATE\W.*MATERIALIZED\W.*VIEW CREATE\W.*MATERIALIZED\W.*VIEW\W.*LOG CREATE\W.*METHOD CREATE\W.*NICKNAME CREATE\W.*OPERATOR CREATE\W.*OR\W.*REPLACE\W.*FUNCTION CREATE\W.*OR\W.*REPLACE\W.*PROCEDURE CREATE\W.*OR\W.*REPLACE\W.*TRIGGER CREATE\W.*OR\W.*REPLACE\W.*VIEW CREATE\W.*ORDERING CREATE\W.*PACKAGE CREATE\W.*PACKAGE\W.*BODY CREATE\W.*PARATITION\W.*SCHEME CREATE\W.*PARTITION\W.*FUNCTION CREATE\W.*PROCEDURE CREATE\W.*PROFILE CREATE\W.*PROXY_TABLE CREATE\W.*PUBLIC\W.*SYNONYM CREATE\W.*RECURSIVE\W.*VIEW CREATE\W.*REPLICATION\W.*GROUP CREATE\W.*ROLE CREATE\W.*ROUTINE\W.*FROM CREATE\W.*RULE CREATE\W.*SCHEMA CREATE\W.*SEQUENCE CREATE\W.*SESSION CREATE\W.*SYNONYM CREATE\W.*TABLE CREATE\W.*TRANSFORM CREATE\W.*TRIGGER CREATE\W.*TYPE CREATE\W.*TYPE\W.*BODY CREATE\W.*TYPE\W.*MAPPING CREATE\W.*USER CREATE\W.*VIEW CREATE\W.*XML\W.*SCHEMA\W.*COLLECTION DATABASE DELETE\W.*DATABASE DELETE\W.*STATISTICS DELETE\W.*USER DESCRIBE DIAGNOSTIC\W.*"VALIDATE\W.*INDEX" DIAGNOSTIC\W.*COSTPRINT DIAGNOSTIC\W.*DUMP\W.*COSTS DIAGNOSTIC\W.*DUMP\W.*SAMPLES DIAGNOSTIC\W.*HELP\W.*COSTS DIAGNOSTIC\W.*HELP\W.*PROFILE DIAGNOSTIC\W.*HELP\W.*SAMPLES DIAGNOSTIC\W.*SET\W.*COSTS DIAGNOSTIC\W.*SET\W.*PROFILE DIAGNOSTIC\W.*SET\W.*SAMPLES DROP DROP\W.*ALIAS DROP\W.*AUTHORIZATION DROP\W.*CAST DROP\W.*CLUSTER DROP\W.*DATABASE DROP\W.*DEFAULT DROP\W.*DIMENSION DROP\W.*DUPLICATE DROP\W.*ERROR\W.*TABLE DROP\W.*FULLTEXT\W.*CATALOG DROP\W.*FULLTEXT\W.*INDEX DROP\W.*FUNCTION DROP\W.*FUNCTION\W.*MAPPING DROP\W.*HASH\W.*INDEX DROP\W.*INDEX DROP\W.*INDEX\W.*EXTENSION DROP\W.*JOIN\W.*INDEX DROP\W.*LIBRARY DROP\W.*LOGIN DROP\W.*MACRO DROP\W.*MATERIALIZED\W.*VIEW DROP\W.*MATERIALIZED\W.*VIEW\W.*LOG DROP\W.*NICKNAME DROP\W.*OPERATOR DROP\W.*ORDERING DROP\W.*OUTLINE DROP\W.*PACKAGE DROP\W.*PARTITION\W.*FUNCTION DROP\W.*PARTITION\W.*SCHEME DROP\W.*PROCEDURE DROP\W.*PROFILE DROP\W.*PUBLIC\W.*SYNONYM DROP\W.*REPLICATION\W.*GROUP DROP\W.*ROLE DROP\W.*ROUTINE DROP\W.*RULE DROP\W.*SEQUENCE DROP\W.*SESSION DROP\W.*STATISTICS DROP\W.*SYNONYM DROP\W.*TABLE DROP\W.*TRANSFORM DROP\W.*TRIGGER DROP\W.*TYPE DROP\W.*TYPE\W.*BODY DROP\W.*TYPE\W.*MAPPING DROP\W.*USER DROP\W.*VIEW DROP\W.*VIEW\W.*HIERARCHY DROP\W.*XML\W.*SCHEMA\W.*COLLECTION DUMP\W.*EXPLAIN EMPTYCAPPED END\W.*LOGGING END\W.*QUERY\W.*LOGGING GIVE GRANT GRANT\W.*LOGON HELP HELP\W.*CAST HELP\W.*COLUMN HELP\W.*CONSTRAINT HELP\W.*DATABASE HELP\W.*ERROR\W.*TABLE HELP\W.*FUNCTION HELP\W.*HASH\W.*INDEX HELP\W.*INDEX HELP\W.*JOIN\W.*INDEX HELP\W.*MACRO HELP\W.*METHOD HELP\W.*PROCEDURE HELP\W.*REPLICATION\W.*GROUP HELP\W.*SESSION HELP\W.*STATISTICS HELP\W.*TABLE HELP\W.*TRANSFORM HELP\W.*TRIGGER HELP\W.*TYPE HELP\W.*USER HELP\W.*VIEW HELP\W.*VOLATILE\W.*TABLE INITIATE\W.*INDEX\W.*ANALYSIS INSERT\W.*EXPLAIN LOCK\W.*TABLE LOGGING\W.*ONLINE\W.*ARCHIVE\W.*OFF LOGGING\W.*ONLINE\W.*ARCHIVE\W.*ON MODIFY\W.*DATABASE MODIFY\W.*PROFILE MODIFY\W.*USER MOVE\W.*TABLE REMOVE\W.*JAVA RENAME RENAME\W.*COLUMN RENAME\W.*FUNCTION RENAME\W.*INDEX RENAME\W.*MACRO RENAME\W.*PROCEDURE RENAME\W.*SEQUENCE RENAME\W.*TABLE RENAME\W.*TRIGGER RENAME\W.*VIEW RENAMECOLLECTION REORG REPLACE\W.*AUTHORIZATION REPLACE\W.*CAST REPLACE\W.*FUNCTION REPLACE\W.*MACRO REPLACE\W.*METHOD REPLACE\W.*ORDERING REPLACE\W.*PROCEDURE REPLACE\W.*RECURSIVE\W.*VIEW REPLACE\W.*TRANSFORM REPLACE\W.*TRIGGER REPLACE\W.*VIEW RESTART\W.*INDEX\W.*ANALYSIS REVOKE REVOKE\W.*LOGON SET\W.*ENCRYPTION\W.*PASSWORD SET\W.*QUERY_BAND SET\W.*ROLE SET\W.*SESSION SET\W.*TIME\W.*ZONE SHOW\W.*CAST SHOW\W.*ERROR\W.*TABLE SHOW\W.*FUNCTION SHOW\W.*HASH\W.*INDEX SHOW\W.*JOIN\W.*INDEX SHOW\W.*MACRO SHOW\W.*METHOD SHOW\W.*PROCEDURE SHOW\W.*REPLICATION\W.*GROUP SHOW\W.*TABLE SHOW\W.*TRIGGER SHOW\W.*TYPE SHOW\W.*VIEW TRUNCATE\W.*TABLE UPDATE\W.*DIMENSION\W.*MEMBER
/
gm

Description

DCL

Submitted by anonymous - 2 months ago