of the long_column. Don't ask why !!!
Al Rusnak
804-734-8453
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 19, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Length of LONG datatype - ANSWER
I'll address your second question, because I don't know
Group,
Please share with me a way to determine the actual length of data in a LONG
data type. As a follow on, what are the pros/cons of using LONG vs. CLOB or
VARCHAR2 ??
TIA
Al Rusnak
804-734-8453
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
I'll address your second question, because I don't know, offhand, the
answer to the first!
IMO, there's almost no advantage to using LONG. There are many
restrictions on its use (e.g., only one LONG in a table), you can't
apply a function to a LONG column, you can't use it in a set operation,