Re: Schema Design Question

Is it possible to concat all data, with a special character between each data, into one varchar2 field, and store the definition of the input type in another table.

Table 1

Input Type  Sequence  Name       DataType
-----------  ----------  ------       ----------
1                1               Name       String
1                2               DOB        Date
1                3               Sal            Int
2                1               company   String

Table 2
Input Type Data

-----------    -----------------------
1                   a&12/12/2001&3000
1                   b&12/13/2001&4000
2                   a&12&1.2&5

Store procedure may be required.

It's just my idea on this question, please advise is it feasible.

KC

"Kumar" <kumar_kmk_at_hotmail.com> wrote in message news:bce41b15.0112271408.1e7d80f2_at_posting.google.com...
> Hi Raghu
> Your solution works fine for the problem I posted, but I think I need
> to think ahead what could be comming as data which makes this solution
> a little problamatic... ( Sorry I did not think of it before)
>
> 1. Some inputs may have 30 fields and some have as little as 5 fields
> so if we assign 30 varchar columns I think it will be a waste of space
> for 25 fields and when i think data running into 1000's of records
> this might be unacceptable.Is there any wayway oracle optimizes
> without wasting space.
>
> 2. As long as i stick to varchars it should be ok though some fields
> may be of size 1 ( varchar(1) ) and some varchar(1000) here there is a
> 999 penalty.
>
> 3. What if one of the fields is a clob, or I have to store a image.
> This I may overcome by having a clob table and image table and store
> appropriate references. I think the first 2 I need a little thinking.
>
> Hey I understand yours is a free advice, but then what do you think
> about these concerns.
>
> Any thoughts.
Received on Sat Dec 29 2001 - 02:38:12 CET