Re: help newbie fromatted ASCII text into cell

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 21 Sep 2004 05:47:14 -0400
Message-ID: <hJ-dndbb8o0lZdLcRVn-sw@comcast.com>

"Andrew" <myfam_at_surfeu.fi> wrote in message news:c5826e91.0409202045.54348112_at_posting.google.com...
| Hi,
| how do I insert formatted ASCII text like this
|
| [start]
| host=a.b.c # host name
| port=123 # port
| increment=1^2 # increment
| [end]
|
| into a VARCHAR2 cell. My problem is
| a. end of lines (appending ||chr(13) seems to help)
| b. spaces in each should be retained
|
|
| Thanks,
| Andrew

straight SQL is

insert into atable(acolumn) values(
' [start]

host=a.b.c             # host name
port=123               # port
increment=1^2          # increment

[end]')

or

insert into atable(acolumn) values(
' [start]'
||chr(10)||'host=a.b.c # host name'
||chr(10)||'port=123 # port'
||chr(10)||'increment=1^2 # increment'
||chr(10)||'[end]'

)

however, you mention 'CELL' which makes me wonder if you're entering this through some user interface and not with straight SQL. what tool are you using to insert the data?

++ mcs Received on Tue Sep 21 2004 - 04:47:14 CDT