• Home
• com.felipebz.zpa
• zpa-checks
• 3.6.0
• source code
• ConcatenationWithNull.html

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

Concatenating a VARCHAR2 value with NULL is no-op. So, the NULL value should be removed.

A concatenation of any other datatype with NULL will cause a implicit cast to VARCHAR2. If this is the desired behavior,
replace the concatenation by a TO_CHAR call to make the intention explicit. See this example:

var := NVL(''||id, 'Empty');


You should use this:

var := NVL(TO_CHAR(id), 'Empty');