Regular Expressions 101

Explanation

Pro

.*any character (except for line terminators), repeated any number of times

\ban ASCII word boundary

Group 1(KEYWORD\s.*;)

KEYWORDthe literal text KEYWORD (case sensitive)

\sany whitespace character

.*any character (except for line terminators), repeated any number of times

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

.*any character (except for line terminators), repeated any number of times

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

.*\b(KEYWORD\s.*;).*

New

1. --      KEYWORD the procedure if data match between Type 1 and Type 2/3 views is not required.
2. KEYWORD SET MESSAGE_TEXT = '***FAILURE : '||V_G_ERR_MSG_01; /*STATEMENT TO THROW USER DEFINED ERROR CODE AND EXCEPTION TO THE CALLER*/