Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to insert/update a column with text data with other columns in a table?
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
Received on Thu Apr 29 2004 - 16:32:13 CDT