SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Decode Function is not working with 'IN' clause properly

Amrutha ChintapalliDec 2 2024

AND (NVL (t.secondary_inventory_name, 'Y') IN (DECODE (:p_sub_inv_name, NULL, NVL (t.secondary_inventory_name, 'Y'), :p_sub_inv_name ) ) )

This CONDITION in query is giving only the data of single parameter value from the list of p_sub_inv_name parameter values. but the same condition used in simple query is working well for the multiple p_sub_inv_name parameter values

This post has been answered by Cookiemonster76 on Dec 3 2024

Jump to Answer

Added on Dec 2 2024

#decode, #oraclesqldeveloper, #parameters, #plsql, #sql, #sql/plsql, #sqlqueryissue

13 comments

376 views

4 mentions