Extracting from LONG datatype column
I have a table with a column specified as the LONG datatype. When selecting data I get the following error: "ORA-00932: INCONSISTENT DATATYPE." Is there a quick way to extract this information?
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
SELECT TO_CHAR(my_long_column) FROM my_table;You can then store the returned value to a variable defined as the VARCHAR2 datatype.