RE: Length of LONG datatype - ANSWER !!!

2002-03-20 Thread Rusnak, George A.
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

Length of LONG datatype

2002-03-19 Thread Rusnak, George A.
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:

Re: Length of LONG datatype

2002-03-19 Thread Paul Baumgartel
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,