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!

How to use Case Statement in where clause with Bind parameter

Pritam DasOct 6 2022

Hi Expert,
I want to use case statement in where clause.Below is my sql query for it.Please help me with this
select distinct structure_name from Test_COA_LEGACY_SEGMENT_VALUES
where segment_name = nvl(:segment_name, segment_name)
and segment_number = nvl(:segment_number, segment_number)

This post has been answered by Frank Kulash on Oct 6 2022

Jump to Answer

Added on Oct 6 2022

#sql

4 comments

2,894 views

1 mention