Question

4
Replies
242
Views
Prakash. Member since 2012 6 posts
Process 360
Posted: 4 years ago
Last activity: 4 years 3 months ago
Closed
Solved

NVL function in where clause of Report Definition

Hi,

How do I configure the report definition to generate an sql like below:

SELECT col1,col2FROM testtable WHERE NVL(col3,'Not Registered')= NVL(Param.inputVal,'Not Registered');

Reporting
Moderation Team has archived post
Share this page LinkedIn