you need to set linesize al least 354 or set column format within linesize 78 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Viraj Luthra Sent: Wednesday, February 14, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Subject: Output in 1 line in the spool file from a sql statement - please help Hello, I need some help. I need all the columns values on 1 line only. that is in the end of this mail you will see the result as, ----------------------------------------------------------------- V$ACCESS SYNONYM 8 PUBLIC -------------------------------------------------------------- I need the above as V$Access Synonym 8 public all with the correct width as defined in the sql statement. Have you any clue as to what to do? I have tried different linesizes... also but no use Regards, Raja -------------------------------------------------- This is the script that I run:- run_sql() { sqlplus -s system/manager@orcl815 <<! set linesize 78 (also tried linesize 1000 but no use) col a format a254 col b format a24 col c format 9999999 col d format a64 set echo off feedback off head off spool 4.lst select substr(object,1,254) a, substr(type,1,24) b, substr(sid,1,7) c, substr(owner,1,64) d from v\$access order by owner / spool off ! cat 4.lst |sed 's/ *$//' > 5.lst } run_sql +++++++++++++++++++++++++++++++++++++++++++++++++++ The output I get is like this:- V$ACCESS SYNONYM 8 PUBLIC DBMS_APPLICATION_INFO PACKAGE 8 SYS Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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).��zǞ��}����ND ��@Bm���� +i��r����h��DNX�_]���w��B�܍z�(�D����z�9���Nu���w�9�&�'��&���+�&���bp��z�� z�?1���x ��lN�D0�Dʋ���_~�&������x%��lzwZ�C�Y��Ơz� ��F���j�"�'(�z-xE� + ;)zYb� .+-��jwb��^��,j�86"��nu楊w��{Z�x��CRP� "�.���ڙ� ����x%��r����hm�ޚ��u�虊.�����,zwm���,�(�f�u�+��^�)ߢ���*'�) ���r���x
