Regular Expressions 101

^start of line

Group 1(.*)

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

Non-Capturing Group(?::)?

?repeats the group contents below at most once:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

$end of line

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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

^(.*)(?::)?$

New

ORA-06550: line 10, column 33:
ORA-20000: Schema "TEST" does not exist or insufficient privileges
PLS-00201: identifier 'A' must be declared: