Hi...
Does anyone know how i can convert existing Long Raw datatype records to be Blobs.
I'm unsure of the syntax and can't seem to find it anywhere.
Thanks in Advance
:confused:
Printable View
Hi...
Does anyone know how i can convert existing Long Raw datatype records to be Blobs.
I'm unsure of the syntax and can't seem to find it anywhere.
Thanks in Advance
:confused:
Hi ,
In Oracle8i a LONG column could be converted to a LOB using the TO_LOB() function.
One of the restrictions on that use was it could not be used to convert a column in an existing table , only during the creation of a new table.
In Oracle9i this conversion is possible using the ALTER TABLE with MODIFY syntax:
Column content is currently a LONG
==================================
ALTER TABLE documents MODIFY (content CLOB);
Column content is currently a LONG RAW
======================================
ALTER TABLE executables MODIFY (content BLOB);
This syntax can only be used for the conversion of LONG and LONG RAW columns.
Cheers
Padmam