Regular Expressions 101

Explanation

Pro

COALESCEthe literal text COALESCE (case sensitive)

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

Group 1(.*?)

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

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

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

Match Information

Detailed match information will be displayed here automatically.

Quick Reference

25 tokens

Regular Expression

COALESCE\((.*?)\)

New

select DISTINCT SUM(case when t0_0.pp is not null  then COALESCE(t0_0.pp,0)
else 0 end) from inventory_coverage_view t0_0 where  LOWER(t0_0.h) ='vg' AND t0_0.id = '9'

Substitution

select DISTINCT SUM(case when t0_0.pp is not null  then COALESCE(t0_0.pp,0)
else 0 end) from inventory_coverage_view t0_0 where  LOWER(t0_0.h) ='vg' AND t0_0.id = '9'