Re: Field consisting of multiple lines

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/11
Message-ID: <6gmi1o$9kk_at_bgtnsc03.worldnet.att.net>#1/1

On 9 Apr 1998 19:59:45 GMT, "Thomas Morgan" <tmorgan_at_mail.sdsu.edu> wrote:

> I wonder if anybody knows if it is possible to fill a VARCHAR field with
>several lines, for example, suppose I have the following lines:
>
>
> Thomas Morgan
> 4247 50th apt 2 San Diego Ca 92115
> (619) 281-4618
>
>is there any way I can manipulate this set of lines as one field in ORACLE.

You could insert the above into one VARCHAR field, I suppose. Try something like this:

SQL> create table test
  2 (address varchar2(100));

SQL> l
  1 insert into test (address) values (   2 'Jonathan Gennick' || chr(10) || '2222 Somewhere Ln'   3 || chr(10)
  4* || 'Some City, MI 48888')

SQL> select * from test;

ADDRESS

---

Jonathan Gennick
2222 Somewhere Ln
Some City, MI 48888

regards,

Jonathan Received on Sat Apr 11 1998 - 00:00:00 CEST