cancel
Showing results for 
Search instead for 
Did you mean: 

USERTEXT NCLOB datatype

SeethaSundaresa
Explorer
0 Kudos
91

Hi, 

Can anyone solve this issue. USERTEXT NCLOB when use in group by got issue. How do need to add in group by clause. Can give me some clear solution.

SeethaSundaresa_0-1718265256921.png

 

View Entire Topic
mfath
Advisor
Advisor
0 Kudos

As the error message suggest, you can't use GROUP BY on LOB datatypes, eg (n)CLOB, BLOB. If you test is shorter than 5000 characters, use the (N)VARCHAR(5000) datatype.