I have one table which contains five columns. One of the columns is defined as LONG RAW. How do I know whether it is BLOB or BFILE?
My other question is how can I convert BFILE data to BLOB? Is there any utility or do I need to write PL/SQL statements?
Thanks in advance.
Just like the BLOB datatype differs from the BFILE datatype, the LONG RAW datatype is different too. The LONG RAW datatype is not a BLOB or a BFILE. The BLOB and BFILE datatypes replace the LONG RAW datatype.
For information on how to convert, please look at the Oracle documentation.
This was first published in May 2006