I have one doubt-
I am trying to use COALESCE function but it does not work
it always returns first value even in table value is blank.
When i checked the table i found "NOT NULL" is "X" in DB, so value is never NULL
to check this i created a table in SE11 , even though i am selecting "initial" flag X or not, DB automatically sets "NOT NULL"
Now i am little bit confused how to deal with this, how to use 'coalesce' function.
If anyone has any idea please clear my doubt.
Thanks in advance