Skip to Content

COALESCE does not work as DB table always sets 'NOT NULL'

Hello Experts,

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

Ashish T.

1.jpg (36.3 kB)
1.jpg (97.0 kB)
2.jpg (62.1 kB)
3.jpg (36.7 kB)
4.jpg (38.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer