Regular Expressions 101

"the literal " (34₁₀ / 42₈ / 22₁₆)

\w+any word character, repeated at least once

"the literal " (34₁₀ / 42₈ / 22₁₆)

Non-Capturing Group(?:\."\w+"){0,2}

{0,2}repeats the group contents below between 0 and 2 times:

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

"the literal " (34₁₀ / 42₈ / 22₁₆)

\w+any word character, repeated at least once

"the literal " (34₁₀ / 42₈ / 22₁₆)

Positive Lookahead(?=\s*\()

\s*any whitespace character, repeated any number of times

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

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.

Search reference

Regular Expression

"\w+"(?:\."\w+"){0,2}(?=\s*\()

New

CREATE TABLE "commerce"."finance"."invoices_1" (
    "abc" NUMBER(15,0),
    "def" VARCHAR2(200),
    "ghi" DATE
);
CREATE TABLE "finance"."invoices_1" (
    "abc" NUMBER(15,0),
    "def" VARCHAR2(200),
    "ghi" DATE
);
CREATE TABLE "invoices_1" (
    "abc" NUMBER(15,0),
    "def" VARCHAR2(200),
    "ghi" DATE
);

CREATE TABLE "invoices_1" ( "abc" NUMBER(15,0),
    "def" VARCHAR2(200),
    "ghi" DATE
);

Regular Expression

Extraction