VARCHAR2 compress

From: Colin McGuire <colinandkaren_at_lycos.co.uk>
Date: 20 Jun 2002 01:18:07 -0700
Message-ID: <ab6cea37.0206200018.727af1ee@posting.google.com>

Hello - I have squillions of long strings that I would like to store in an Oracle 8 database. Because of the size of the strings I would like them to take the minimum amount of space in my database/on the server.

The contrived SQL I would like to enter would be something like

CREATE TABLE tblTest(id NUMBER PRIMARY KEY,

                     storedate DATE,
                     staffid   VARCHAR2(5),
                     otherdata COMPRESSED VARCHAR2(3000)
                    );

So how is this done or does it need to be done (ie does Oracle automatically compress 'otherdata' for me) ?

Thank you
Colin Received on Thu Jun 20 2002 - 03:18:07 CDT