Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Proper format for XML?
I would definitely use a LOB (CLOB or BLOB) datataye as the (old) datatype long has too much limitations.
Thomas
Thelonious Georgia wrote:
>
> Hey all-
>
> I'd like to store an XML resultset in the database for later querying. The
> number of potential rows is currently unknown, but 50-75k rows is certainly
> conceivable. I'm wondering if I should use the LONG type for that column, or
> perhaps a BLOB.
>
> Thanks for any info,
>
> Theo
-- _______________________________________________________________________ Siemens Switzerland Ltd, Softwarehaus, ES41 Thomas Jegen, Software Engineer Albisriederstrasse 245, CH-8047 Zürich Phone +41 (0)1 495 3438, Fax +41 (0)1 406 5340 mailto:thomas.jegen@siemens.ch, Internet: http://www.siemens.ch/Received on Wed May 16 2001 - 01:55:22 CDT