<div>
coalesce will return the first value that is not null.<br />
<br />
in your example, if ? (variable, user input ..) is null, it will result in:<br />
WHERE ACC_LV_CODE_ST like ACC_LV_CODE_ST<br />
which means: match all rows<br />
<br />
if ? is passed (aka not null), it will be:<br />
WHERE ACC_LV_CODE_ST like ?<br />
<br />
&nbsp;hope this clarifies<br />

</div>


coalesce will return the first value that is not null.

in your example, if ? (variable, user input ..) is null, it will result in:
WHERE ACC_LV_CODE_ST like ACC_LV_CODE_ST
which means: match all rows

if ? is passed (aka not null), it will be:
WHERE ACC_LV_CODE_ST like ?

 hope this clarifies


<div>
<a href="http://stackoverflow.com/questions/950084/oracle-differences-between-nvl-and-coalesce" rel="ugc">http://stackoverflow.com/questions/950084/oracle-differences-between-nvl-and-coalesce</a>
</div>


http://stackoverflow.com/questions/950084/oracle-differences-between-nvl-and-coalesce [http://stackoverflow.com/questions/950084/oracle-differences-between-nvl-and-coalesce]

<div>
<div class="content wysiwyg-content">
Could you Explain COALESCE function in Oracle<br />
<br />
<br />
WHERE ACC_LV_CODE_ST like COALESCE(?, ACC_LV_CODE_ST)
</div>
</div>


Could you Explain COALESCE function in Oracle


WHERE ACC_LV_CODE_ST like COALESCE(?, ACC_LV_CODE_ST)

Could you Explain COALESCE  function in Oracle

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.