Convert the content of a 'LONG' column to a string
One of columns of the table is defined as 'LONG'. It may not be a good idea to define it as 'LONG' but that's another story. Now the 'LONG' column holds some text string. I need to do a substring on this column, but I got a incompatible datatype error. So I'm thinking to convert 'LONG' to a string first, then do substring. How am I going to do it? Shed some light please. THanks.