org.sonar.l10n.plsqlopen.rules.plsql.UnnecessaryLike.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zpa-checks Show documentation

Z PL/SQL Analyzer :: Checks

The newest version!


  Using a LIKE condition without a wildcard (% or _) is suspicious. A maintainer can suppose whether a wildcard is
  forgotten or it is meant as equality test.


Noncompliant Code Example

if (last_name like 'Smith') ...


Compliant Solution

if (last_name like 'Smith%') ...

-- or
if (last_name = 'Smith') ...