hello,
i have the following line in a query:
AND (mmt.ATTRIBUTE1)= NVL(:P _Subject,mmt.ATTRIBUTE1)
It gives me only the not null "mmt.ATTRIBUTE1" records when the parameter is not entered.
How can i modify this in order to bring all the records even where the column mmt.ATTRIBUTE1 is NULL
Thank you..
How to bring all records
Who is online
Users browsing this forum: No registered users and 3 guests