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

wolfgang_nl_at_hotmail.com (W.Benvort) wrote in message news:<9a0caaaf.0404291007.3bf67e30_at_posting.google.com>...
> 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

1- What does the table describe look like?
2- What does the input sqlldr file look like?
3- And what did you control cards look like?

I realize the above is an example of the data you are dealing with but you did not state it was taken from the input file or just a display of some of the information you are working with.

If none of the MS Server text data exceeds 4000 bytes you can store it in a varchar2 column otherwise I think this is a job for a CLOB.

HTH -- Mark D Powell -- Received on Thu Apr 29 2004 - 19:20:24 CDT