Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to insert/update a column with text data with other columns in a table?

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

From: W.Benvort <wolfgang_nl_at_hotmail.com>
Date: 29 Apr 2004 11:07:15 -0700
Message-ID: <9a0caaaf.0404291007.3bf67e30@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 Received on Thu Apr 29 2004 - 13:07:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US