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