Re: Max number of Tables ?

surman_at_oracle.com (Scott Urman) wrote: >  

>
> You don't want each message to be a separate table, you want each message to
> be a separate row in the same table.
 

This sounds good, but can each message be a separate row if each message is composed of variable fields:

  ex: Message 1 is made up of the following

        Field 1 is INTEGER
        Field 2 is CHARACTERS
        Field 3 is REAL
        Field 4 is CHARCATERS

       Message 2 is made up of the following

        Field 1 is CHARACTERS
        Field 2 is CHARACTERS
        Field 3 is REAL
        Field 4 is INTEGER
        Field 5 is INTEGER(80)