Re: How does ORACLE handle a query that includes a LONG RAW data type?

Only one LONG RAW can be stored per table, it is always the last column in the table and it is stored as a variable length field (i.e. space is allocated as needed and chained as necessary). I would not recommend using LONG RAWS because they are very inflexable. If you have a requirement of unstructured data, why not use the Oracle8 LOB feature, that are more efficient and use locators.

Regards
David Russell

 Tony Geros wrote in message <01bd74a8$d6dd5880$5ab90ccb_at_station1>...
>Hi,
>
>Does ORACLE treat LONG RAW datatypes in the same manner as fixed length
>fields, or would ORACLE choose to create a fixed space to store the data
>in, regardless of the total size of LONG RAW data in the table?
>
>Tony
Received on Sat May 02 1998 - 17:03:44 CDT