Jon, sorry it was a 9i thing.
joe
[EMAIL PROTECTED] 08/20/01 10:10PM
Joe:
Can you tell me if you were able to do this?
I just tried it and it errored out on me:
SQL create
table test_lob (col1 varchar2(30), col_lob long);
Table
created.
SQL desc
test_lobName
Null?
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
Title: Message
Joe:
Can you tell me if you were able to do this?
I just tried it and it errored out on me:
SQL create
table test_lob (col1 varchar2(30), col_lob long);
Table
created.
SQL desc
test_lobName
Null? Type-