Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of JOE TESTASent:
Monday, August 20, 2001 4:26 PMTo: Multiple recipients of list
ORACLE-LSubject: changing long to lob
while looking thru the migration guide(for downgrade info in case it
happens),
alter table
In 8i you can use ... (straight from SQL reference manual)
TO_LOB
Purpose Converts LONG or LONG RAW values in the column long_column to LOB
values. You can apply this function only to a LONG or LONG RAW column, and
only in the SELECT list of a subquery in an INSERT statement (see INSERT
on page
while looking thru the migration guide(for downgrade info in case it
happens),
alter table table_name modify long_col clob;
and supposedly POOF its now a clob.
interesting.
joe
]] On Behalf Of JOE TESTASent:
Monday, August 20, 2001 4:26 PMTo: Multiple recipients of list
ORACLE-LSubject: changing long to lob
while looking thru the migration guide(for downgrade info in case it
happens),
alter table table_name modify long_col clob;
and supposedly POOF its