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

On 29 Apr 2004 11:07:15 -0700, wolfgang_nl_at_hotmail.com (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

What do you mean by "column contains several rows of data. "? Columns don't contain rows. Rows contain columns, not vice versa.

By your example, I'd guess that you're expecting a row with server name, ip address, and a comment, followed by several other rows with more comments that relate to that server name and/or ip address. Further, your example seems to indicate that these additional rows will have neither the server name nor the ip address. If so, this will never work, as there is nothing to relate the additional rows to the first one. Received on Thu Apr 29 2004 - 14:37:31 CDT