Re: How to insert/update a column with text data with other columns in a table?

Thanks Howards & Evevryone

It is very nice to saw the suggestion form you. Could you send some sample about clob column as you discussed, if posible?

REgards

Wolfgang

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4091745c$0$438$afc38c87_at_news.optusnet.com.au>...
> W.Benvort wrote:
>
> > Hi,
> >
> > How should we insert/update a (text data) column in a table?
> >
> > I have a table &#8220;Server&#8221; (Server Name, IP Address,
> > System_Info).
> >
> > The &#8220;System_Info&#8221; column contains several rows of data. On
> > the other side the
> > &#8220;Server Name&#8221; & &#8220;IP Address&#8217; column contain
> > only one row.
> >
> > I was trying to insert/update the &#8220;System_Info&#8221; column via
> > SQLLOADER but I didn&#8217;t get the desired results.
> >
> > Could some one suggest how should we insert or update the column like
> > &#8220;System_Info&#8221; in a table, which contains several rows of
> > data (Text data) with other columns?
> >
> > Thanks
> >
> > Wolfgang
> >
> >
> >
> >
> > For Example:
> >
> >
> > Server Name IP Address System_Info
> >
> > Test 127.0.0.1 OS Name: Microsoft
> > Windows
> > Version:
> > 5.0.2195
> > Service Pack: Total
> > Virtual Memory:
> > 411944
>
>
> Re-design your table, basically.
>
> For example, have a table just for IP Address. A separate table for
> Server Name, which can be linked to the one for IP Address. And a third
> for System Info, which will have IP as part of its primary key, and
> would therefore in your example contain 3 records for 127.0.0.1. To get
> the report out almost as you've displayed it here, you'd join all three
> tables together on IP Address.
>
> Or, if you don't fancy three tables to do the job, make the SYSTEM_INFO
> column a CLOB data type, and just insert multiple-lines of what amounts
> to free-form text.
>
> Or, if you want to get silly, create the SYSTEM_INFO column as a nested
> table or Varray.
>
> It all depends, really.
>
> Regards
> HJR
Received on Thu Apr 29 2004 - 22:33:56 CDT