Re: Two LONG RAW fields in one table?

oracle 8 has CLOB, BLOB, BFILE types, clob = character large object kinda like long, blob = binary large object kinda like raw, bfile new type which is a pointer to the object stored at the operating system filesystem(be it unix/nt, etc). you can have multiple clob, blob at the table level, oracle 8 also does NOT store the info in the table but gives you the capability to store the LOB in some other tablespace.

hth, joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net

Vice-President Ohio Oracle Users Group, try http://web.scioto.net/jtesta

That is also the place to find the FREE, "how do I build a second,
third, etc, instance, without using oracle's installer, database
scripts.
ICQ UIN: 4252226(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).