[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: Re: ODTUG-SQLPLUS-L Digest -- Volume 2002, Number 197
From: "Phanish" <phanish.bharadwaj () itcinfotech ! com>
Date: 2002-07-16 9:18:41
[Download RAW message or body]
check out your wrap option. Set it on and check it out. When you say show
wrap it should show "wrap : lines will be wrapped" and not "wrap : lines
will be truncated"
Phanish
----- Original Message -----
To: "Multiple recipients of list ODTUG-SQLPLUS-L"
<ODTUG-SQLPLUS-L@fatcity.com>
Sent: Tuesday, July 16, 2002 2:35 PM
> ODTUG-SQLPLUS-L Digest Tue, 16 Jul 2002 Volume 2002,
Number 197
>
> In This Issue:
>
> Subject Author
> ------------------------------------------- ---------------------------
-----
> need CHR(10) help Lorrie Bridges
<lorrie.bridges@a
> RE: need CHR(10) help Andy Asensio
<AAsensio@freshdelm
> RE: need CHR(10) help Jones Allen
<Allen.Jones@vpgroup
>
> ------------------------------------------------------------
>
> From: Lorrie Bridges <lorrie.bridges@acu.edu>
> Date: Mon, 15 Jul 2002 16:37:26 -0500
> Subject: need CHR(10) help
>
> --=====================_271850900==_.ALT
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> 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
>
> --=====================_271850900==_.ALT
> Content-Type: text/html; charset="us-ascii"
>
> <html>
> 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>
> </html>
>
> --=====================_271850900==_.ALT--
>
>
>
> ------------------------------
>
> From: Andy Asensio <AAsensio@freshdelmonte.com>
> Date: Mon, 15 Jul 2002 17:46:21 -0400
> Subject: RE: need CHR(10) help
>
> is the column defined as follows:
>
> COLUMN COLUMN_NAME FORMAT A7 TRUNC;
>
> If so, removed the TRUNC and put in WRAP;
>
> Good Luck
>
> Andy Asensio
> Del Monte Fresh Produce N.A.
> Phone: (305)520-8121
> Fax: (305)520-8299
>
>
> > -----Original Message-----
> > From: Lorrie Bridges [SMTP:lorrie.bridges@acu.edu]
> > Sent: Monday, July 15, 2002 6:38 PM
> > To: Multiple recipients of list ODTUG-SQLPLUS-L
> > Subject: need CHR(10) help
> >
> > 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
> >
>
>
> ------------------------------
>
> From: Jones Allen <Allen.Jones@vpgroup.com>
> Date: Mon, 15 Jul 2002 14:58:31 -0700
> Subject: RE: need CHR(10) help
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C22C4A.C1F00590
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> I copied your SQL statement and ran it. I got the following:
>
> SQL> select 'Line 1' || CHR(10) || 'Line 2' || CHR(10) || 'Line 3' from
> dual;
>
> 'LINE1'||CHR(10)||'L
> --------------------
> Line 1
> Line 2
> Line 3
>
>
> SQL>
>
> I'm using Reflection on a PC to connect to a UNIX server (HPUX 11.11)
> running Oracle 8.1.7. The reflection connection is set to terminal type
> VT400-7, emulating a VT220, using (rightly or wrongly) the DEC
Supplemental
> Host character set and Windows PC character set. The NLS_LANG environment
> variable is set to blank. The character set of the database is WE8DEC.
The
> nls_language parameter is "AMERICAN" and the nls_territory is "AMERICA".
>
> Hope this helps.
>
> -----Original Message-----
> Sent: Monday, July 15, 2002 3: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
>
> ------_=_NextPart_001_01C22C4A.C1F00590
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <html xmlns:o="urn:schemas-microsoft-com:office:office" > \
> xmlns:w="urn:schemas-microsoft-com:office:word" > \
> xmlns="http://www.w3.org/TR/REC-html40">
> <head>
> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; > charset=iso-8859-1">
>
>
> <meta name=ProgId content=Word.Document>
> <meta name=Generator content="Microsoft Word 9">
> <meta name=Originator content="Microsoft Word 9">
> <link rel=File-List href="cid:filelist.xml@01C22C10.86135CF0">
> <!--[if gte mso 9]><xml>
> <o:OfficeDocumentSettings>
> <o:DoNotRelyOnCSS/>
> </o:OfficeDocumentSettings>
> </xml><![endif]--><!--[if gte mso 9]><xml>
> <w:WordDocument>
> <w:Zoom>0</w:Zoom>
> <w:DocumentKind>DocumentEmail</w:DocumentKind>
> <w:EnvelopeVis/>
> </w:WordDocument>
> </xml><![endif]-->
> <style>
> <!--
> /* Font Definitions */
> @font-face
> {font-family:Georgia;
> panose-1:2 4 5 2 5 4 5 2 3 3;
> mso-font-charset:0;
> mso-generic-font-family:roman;
> mso-font-pitch:variable;
> mso-font-signature:647 0 0 0 159 0;}
> @font-face
> {font-family:Tahoma;
> panose-1:2 11 6 4 3 5 4 4 2 4;
> mso-font-charset:0;
> mso-generic-font-family:swiss;
> mso-font-pitch:variable;
> mso-font-signature:553679495 -2147483648 8 0 66047 0;}
> @font-face
> {font-family:"Lucida Console";
> panose-1:2 11 6 9 4 5 4 2 2 4;
> mso-font-charset:0;
> mso-generic-font-family:modern;
> mso-font-pitch:fixed;
> mso-font-signature:-2147482993 6144 0 0 31 0;}
> /* Style Definitions */
> p.MsoNormal, li.MsoNormal, div.MsoNormal
> {mso-style-parent:"";
> margin:0in;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";}
> p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
> {margin:0in;
> margin-bottom:.0001pt;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";}
> p
> {margin-right:0in;
> mso-margin-top-alt:auto;
> mso-margin-bottom-alt:auto;
> margin-left:0in;
> mso-pagination:widow-orphan;
> font-size:12.0pt;
> font-family:"Times New Roman";
> mso-fareast-font-family:"Times New Roman";}
> span.EmailStyle16
> {mso-style-type:personal-reply;
> mso-ansi-font-size:11.0pt;
> mso-ascii-font-family:Georgia;
> mso-hansi-font-family:Georgia;
> mso-bidi-font-family:Arial;
> color:navy;}
> @page Section1
> {size:8.5in 11.0in;
> margin:1.0in 1.25in 1.0in 1.25in;
> mso-header-margin:.5in;
> mso-footer-margin:.5in;
> mso-paper-source:0;}
> div.Section1
> {page:Section1;}
> -->
> </style>
> </head>
>
> <body lang=EN-US style='tab-interval:.5in'>
>
> <div class=Section1>
>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'>I copied your SQL statement and ran it.<span
> style="mso-spacerun: yes"> </span>I got the > \
> following:<o:p></o:p></span></font></span></p>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'><![if > \
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'>SQL> select 'Line 1'<span
> style="mso-spacerun: yes"> </span>|| CHR(10) || 'Line 2' || > CHR(10) ||
> 'Line 3' from dual;</span></font><font size=2 color=navy > face="Lucida \
> Console"><span style='font-size:10.0pt;font-family:"Lucida > \
> Console";color:navy;mso-color-alt: windowtext'><o:p></o:p></span></font></p>
>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'><![if !supportEmptyParas]> > \
> ;<![endif]></span></font><font size=2 color=navy face="Lucida Console"><span > \
> style='font-size:10.0pt; font-family:"Lucida > \
> Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida > Console";color:navy'>'LINE1'||CHR(10)||'L</span></font><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida > \
> Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida > Console";color:navy'>--------------------</span></font><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida > \
> Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'>Line 1</span></font><font > size=2
> color=navy face="Lucida Console"><span > style='font-size:10.0pt;font-family:
> "Lucida > Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> \
> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'>Line 2</span></font><font > size=2
> color=navy face="Lucida Console"><span > style='font-size:10.0pt;font-family:
> "Lucida > Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> \
> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'>Line 3</span></font><font > size=2
> color=navy face="Lucida Console"><span > style='font-size:10.0pt;font-family:
> "Lucida > Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> \
> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'><![if > \
> !supportEmptyParas]> <![endif]></span></font><font size=2 color=navy \
> face="Lucida Console"><span > style='font-size:10.0pt; font-family:"Lucida > \
> Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'><![if > \
> !supportEmptyParas]> <![endif]></span></font><font size=2 color=navy \
> face="Lucida Console"><span > style='font-size:10.0pt; font-family:"Lucida > \
> Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> /p>
> <p class=MsoNormal > style='mso-layout-grid-align:none;text-autospace:none'><font
> size=2 color=navy face="Lucida Console"><span > style='font-size:10.0pt;
> font-family:"Lucida Console";color:navy'>SQL> </span></font><font > size=2
> color=navy face="Lucida Console"><span > style='font-size:10.0pt;font-family:
> "Lucida > Console";color:navy;mso-color-alt:windowtext'><o:p></o:p></span></font><> \
> /p>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'><![if > \
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'>I’m using Reflection on a PC to connect to a > UNIX \
> server (HPUX 11.11) running Oracle 8.1.7.<span style="mso-spacerun: > yes">
> </span>The reflection connection is set to terminal type VT400-7, > emulating a
> VT220, using (rightly or wrongly) the DEC Supplemental Host character > set and
> Windows PC character set.<span style="mso-spacerun: yes"> > </span>The
> NLS_LANG environment variable is set to blank.<span > style="mso-spacerun:
> yes"> </span>The character set of the database is WE8DEC.<span
> style="mso-spacerun: yes"> </span>The nls_language parameter is > \
> “AMERICAN” and the nls_territory is > \
> “AMERICA”.<o:p></o:p></span></font></span></p>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'><![if > \
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'>Hope this > helps.<o:p></o:p></span></font></span></p>
>
> <p class=MsoNormal><span class=EmailStyle16><font size=2 > color=navy
> face=Georgia><span > style='font-size:11.0pt;mso-bidi-font-size:12.0pt;
> font-family:Georgia'><![if > \
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>>
> <p class=MsoNormal style='margin-left:.5in'><font size=2 > color=black
> face=Tahoma><span > \
> style='font-size:10.0pt;font-family:Tahoma;color:black'>-----Original \
> Message-----<br> <b><span style='font-weight:bold'>From:</span></b> Lorrie Bridges
> [mailto:lorrie.bridges@acu.edu]<br>
> <b><span style='font-weight:bold'>Sent:</span></b> Monday, July 15, > 2002 3:38
> PM<br>
> <b><span style='font-weight:bold'>To:</span></b> Multiple recipients > of list
> ODTUG-SQLPLUS-L<br>
> <b><span style='font-weight:bold'>Subject:</span></b> need CHR(10) > \
> help</span></font></p>
> <p class=MsoNormal style='margin-left:.5in'><font size=3 > face="Times New \
> Roman"><span style='font-size:12.0pt'><![if > \
> !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
> <p class=MsoNormal style='margin-left:.5in'><font size=3 > color=black
> face="Times New Roman"><span > style='font-size:12.0pt;color:black'>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 style='mso-special-character:line-break'>
> <![if !supportLineBreakNewLine]><br > style='mso-special-character:line-break'>
> <![endif]></span></font><font color=black><span > style='color:black;mso-color-alt:
> windowtext'><o:p></o:p></span></font></p>
>
> <x-sigsep>
>
> <p style='margin-left:.5in'></x-sigsep><font size=3 color=black
> face="Times New Roman"><span > style='font-size:12.0pt;color:black'>Lorrie
> Bridges <br>
> Systems Programmer/Analyst<br>
> <br>
> Abilene Christian University <br>
> Computer and Network Services <br>
> Ph. (915)674-2831<br>
> <br>
> "</span></font><b><i><font color=purple><span > style='color:purple;
> font-weight:bold;font-style:italic'>You only live once - but if you > work it
> right - once is enough.</span></font></i></b><font color=black><span
> style='color:black'>" -Joe E. Lewis</span></font><font > color=black><span
> style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>> </p>
>
> </div>
>
> </body>
>
> </html>
>
> ------_=_NextPart_001_01C22C4A.C1F00590--
>
> ------------------------------
>
> End Of ODTUG-SQLPLUS-L Digest -- Volume 2002, Number 197
> ********************************************************
>
> 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: ODTUG SQL*Plus Mailing List
> INET: ODTUG-SQLPLUS-L@fatcity.com
>
> 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).
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: Phanish
INET: phanish.bharadwaj@itcinfotech.com
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