How to use NVL function in DB adapter
How to NVL function in DB adapter
I want to use NVL function in DB adapter but it seems it not supported. Is there any workaround available?Below is my sql query.
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)
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):