hi guys

hope everyone will be fine.

I am facing a problem in using decode query function. actually i have three fields in my table

FieldA VARCHAR
FieldB VARCHAR
FeildC Long

now in Fielda if there is '+' then Field C should be shown. I am writing query like this.

select FieldA, decode(FieldA,'+',FieldC) from abc

i am getting this error

"ORA-00997: Illegal use of LONG datatype"

is it means that decode can't be used with the LONG datatype.

please help