VARCHAR2 size question

Hi there,

I'm newby in Oracle and I have a problem with a VARCHAR datatype filed in a table in ORACLE 7.

The issue is I have a table which contains several columns or field with VARCHAR2(2000) datatype. Those fields due to implementation requirement needs to grow i mean we need to store about 2Mbytes in the value that represent the field. I was thinking to use the LONG datatype but unfortunately in Oracle 7 only one column in the table can be LONG and i have more than one field in the same table which need to store about 2Mbytes.

The first idea came to my mind is in order to store the value of say my attribute i should use 10 columns or fields in the table and then use an algorithm to store and retrieve the data into/from those 10 fields. The performance in this case is not a big issue because it is for a simulator.

Is there anybody can help me out with a better solution that this poor one?

Thanks a lot in advance for your help
Alejandro Received on Fri Oct 25 2002 - 07:46:08 CDT