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 -> Re: How Do I insert a Carriage Return in a String?

Re: How Do I insert a Carriage Return in a String?

From: Ken Madsen <madsenkj_at_no-spampe-nelson.com>
Date: Mon, 19 Oct 1998 13:03:10 -0700
Message-ID: <362B9AFE.45C9D1A@no-spampe-nelson.com>

You could try:

FIELD1|| CHR(13) || CHR(10) || FIELD2 Assuming your database char set is ASCII.

--
Ken Madsen Received on Mon Oct 19 1998 - 15:03:10 CDT

This message: [ Message body ]
Next message: Andrew Gillespie.: "Developer 2000"
Previous message: Jeremiah Wilton: "Re: Why Backup Temp and Rollback segs?"
In reply to: Eric Jodoin: "How Do I insert a Carriage Return in a String?"
Next in thread: Steven H. Meller: "Re: How Do I insert a Carriage Return in a String?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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