RE: Easy Doubt in sql/plus
With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
Title: RE: Easy Doubt in sql/plus Probe this. SQL set pages 0 SQL set feed off SQL set head off SQL set linesize 1000 SQL set trims on SQL r 1 select cod_estado || chr(10) || 2 des_estado 3* from co_estados CO CORRECTO AV AVISADO SS SUSPENDIDO EJ EN PROCESO EXTRAJUDICIAL PJ EN PROCESO JUDICIAL DI DEUDOR INCOBRABLE CF CUENTA FINAL bye. gmon. -Mensaje original- De: Eriovaldo do Carmo Andrietta [mailto:[EMAIL PROTECTED]] Enviado el: Miercoles 21 de Marzo de 2001 15:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
or this messy way: select column1 || chr(10) || column2 || chr(10) || column3 || chr(10 . || column99 / chr(10) is a return command [EMAIL PROTECTED] 03/21/01 01:20PM With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
SELECT column1||chr(10)||column2||chr(10)||columnN from table; Rick -Original Message- From: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 21, 2001 1:03 PM To: Multiple recipients of list ORACLE-L Subject: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
Eriovaldo, Try this... Select Col1 || Chr(10) || Col2 || Chr(10) || Col3 || Chr(10) || Col4 As TheList From Table; Results... THELIST --- Value of Col1 Value of Col2 Value of Col3 Value of Col4 Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Eriovaldo do Carmo Andrietta Sent: Wednesday, March 21, 2001 12:03 PM To: Multiple recipients of list ORACLE-L Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
Re: Easy Doubt in sql/plus
No, using only one statment select like select * from tab, what can i set before ? Eriovaldo do Carmo Andrietta [EMAIL PROTECTED] ICQ #102604225 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 21, 2001 3:20 PM With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: mircoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
isn't that a bit of overkill? select column1||chr(10), column2||chr(10),. from table; should do it From: "Trassens, Christian" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Easy Doubt in sql/plus Date: Wed, 21 Mar 2001 10:20:43 -0800 With subqueries. Regards. -Mensaje original- De: Eriovaldo do Carmo Andrietta [SMTP:[EMAIL PROTECTED]] Enviado el: miƩrcoles 21 de marzo de 2001 19:03 Para: Multiple recipients of list ORACLE-L Asunto: Easy Doubt in sql/plus Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo do Carmo Andrietta INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Trassens, Christian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).
RE: Easy Doubt in sql/plus
Eriovaldo, If you don't want to have to mess around with your SQL adding chr(10), and since you said in SQL*Plus, you could use column commands: SQL column dname newline SQL column loc newline 1* select * from dept SQL / 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS You can also look into using fold_after or fold_before with the col(umn) command. Not that I think the column commands approach is any better or worse, and, it *is* less typing to do the char(10) approach -- just wanted to bring up another approach that hadn't been mentioned. Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- Carmo Andrietta Sent: Wednesday, March 21, 2001 12:03 PM To: Multiple recipients of list ORACLE-L Hi Friends : How can I do for put each column in new line using sql/plus Example : Select * from tab; and the result sould be : 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' and not 'value of column1' 'value of column2' 'value of column3' 'value of column4' 'value of column5' Thanks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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).