[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: RE: need CHR(10) help
From: "BEGENWALD, ANTHONY J (CONTRACTOR)" <ANTHONY.J.BEGENWALD () dfas ! mil>
Date: 2002-07-16 14:53:23
[Download RAW message or body]
Try this:
set heading off pause off
column nwline format a200 newline
select 'Line 1' nwline
,'Line 2' nwline
,'Line 3' nwline
from dual
/
set heading on pause on
-----Original Message-----
Sent: Monday, July 15, 2002 5:38 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Hello,
I have to get some output in a certain format.
I want the following results from the query
select 'Line 1' || CHR(10) || 'Line 2' || CHR(10) || 'Line 3' from dual;
Line 1
Line 2
Line 3
However, the results I get are:
Line1
Just the first line appears; the other lines will not show up.
Is there a setting that has to be turned on or off first??
Lorrie Bridges
Systems Programmer/Analyst
Abilene Christian University
Computer and Network Services
Ph. (915)674-2831
"You only live once - but if you work it right - once is enough." -Joe E. Lewis
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2715.400" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=812222914-16072002><FONT face=Arial color=#0000ff size=2>Try
this:</FONT></SPAN></DIV>
<DIV><SPAN class=812222914-16072002><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=812222914-16072002><FONT face=Arial color=#0000ff size=2>set
heading off pause off<BR>column nwline format a200 newline<BR>select 'Line 1'
nwline<BR> ,'Line 2'
nwline<BR> ,'Line 3' nwline<BR>from
dual<BR>/<BR>set heading on pause on<BR></FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Lorrie Bridges
[mailto:lorrie.bridges@acu.edu]<BR><B>Sent:</B> Monday, July 15, 2002 5:38
PM<BR><B>To:</B> Multiple recipients of list
ODTUG-SQLPLUS-L<BR><B>Subject:</B> need CHR(10)
help<BR><BR></FONT></DIV>Hello,<BR><BR>I have to get some output in a certain
format.<BR>I want the following results from the query <BR>select 'Line
1' || CHR(10) || 'Line 2' || CHR(10) || 'Line 3' from dual;<BR><BR>Line
1<BR>Line 2<BR>Line 3<BR><BR>However, the results I get
are:<BR>Line1<BR><BR>Just the first line appears; the other lines will not
show up.<BR>Is there a setting that has to be turned on or off
first??<BR><BR><BR><X-SIGSEP>
<P></X-SIGSEP>Lorrie Bridges <BR>Systems Programmer/Analyst<BR><BR>Abilene
Christian University <BR>Computer and Network Services <BR>Ph.
(915)674-2831<BR><BR>"<FONT color=#800080><B><I>You only live once - but if
you work it right - once is enough.</I></B></FONT>" -Joe E.
Lewis<BR></P></BLOCKQUOTE></BODY></HTML>
Thanks to everyone for making ODTUG 2002 a great success! Plan now
for next year's conference: Loews Miami Beach, Florida, June 22-27, 2003.
--
Author: BEGENWALD, ANTHONY J (CONTRACTOR)
INET: ANTHONY.J.BEGENWALD@DFAS.MIL
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic