Regular Expressions 101

Positive Lookbehind(?<=create\sor\sreplace\spackage\sbody\ssomething\.)

createthe literal text create (case sensitive)

\sany whitespace character

orthe literal text or (case sensitive)

\sany whitespace character

replacethe literal text replace (case sensitive)

\sany whitespace character

packagethe literal text package (case sensitive)

\sany whitespace character

bodythe literal text body (case sensitive)

\sany whitespace character

somethingthe literal text something (case sensitive)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\S*any non-whitespace character, 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

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(?<=create\sor\sreplace\spackage\sbody\ssomething\.)\S*

New

create or replace package body something.pkg_test is

create or replace package body something.pkg_test is