CODEWITHSUNDEEP
databaseoracle-databasenvl
n7rider
n7rider

Reputation: 487

Why does the NVL2 function don't accept LONG values in its second and third parameters?

The official Oracle database documentation says that the NVL2 function doesn't allow values of type LONG in its second and third parameters though it doesn't explain why.

Why do we have this restriction? Is there any specific reason for this restriction?

Upvotes: 1

Views: 87

Answers (1)

gvenzl
gvenzl

Reputation: 1891

Because LONG columns are long, loooong (pun intended :)) deprecated and shouldn't be used anymore: Oracle 9.0.1 - Deprecated and Desupported Features

Upvotes: 3

Related Questions