wolfgang_nl@hotmail.com (W.Benvort) wrote in message news:<9a0caaaf.0404291007.3bf67e30@posting.google. com>...
> Hi,
>
> How should we insert/update a (text data) column in a table?
>
> I have a table “Server” (Server Name, IP Address,
> System_Info).
>
> The “System_Info” column contains several rows of data. On
> the other side the
> “Server Name” & “IP Address’ column contain
> only one row.
>
> I was trying to insert/update the “System_Info” column via
> SQLLOADER but I didn’t get the desired results.
>
> Could some one suggest how should we insert or update the column like
> “System_Info” 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 --