W.Benvort wrote:

> 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


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