Regular Expressions 101

Community Patterns

v1.colName, v2.colName ==> or decode( v1.colName, v2.colName, 1, 0) = 0

0

Regular Expression
PCRE2 (PHP >=7.3)

/
,{0,1} \w+.(\w+), \w+.(\w+)
/
gm

Description

For Oracle DB, as it doesn't consider null != informed DATE, and considers null != null.

For the WHERE clause.

= 0 to get differences = 1 to get "sameness"

Submitted by R. Moreno - 3 years ago