From oracle-l-bounce@freelists.org Thu Jan 6 08:07:57 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j06E7ve05511 for ; Thu, 6 Jan 2005 08:07:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j06E7vn05506 for ; Thu, 6 Jan 2005 08:07:57 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 743FD72C477; Thu, 6 Jan 2005 09:14:31 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17018-86; Thu, 6 Jan 2005 09:14:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8D5F272C03E; Thu, 6 Jan 2005 09:13:08 -0500 (EST) Message-ID: <9051.193.172.248.131.1105020810.squirrel@193.172.248.131> In-Reply-To: References: Date: Thu, 6 Jan 2005 15:13:30 +0100 (CET) Subject: Re: sqlplus extract question... From: "Carel-Jan Engel" To: cstephens16@gmail.com Cc: "Mercadante, Thomas F" , oracle-l@freelists.org User-Agent: SquirrelMail/1.4.3a MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 14425 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Chris, This is not a series of columns, but just one big column...... You created one big concatenated string. Try the 'set colsep ,' command in sqlplus to change the column-delimiter to a comma, and forget about the ||','|| thingies. Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === > sure, the titles stop at h.NAICS_CODE||'","'||.... > > SET LINESIZE 32767 > SET PAGES 10000 > SET LINES 1024 > > ACCEPT fac_id NUMBER PROMPT 'Enter fac_id:' > > spool c:\FAC_CHAR.txt > > select h.FAC_ID ||'","'|| > h.ORIS_CODE||'","'|| > h.FACILITY_NAME||'","'|| -- snip > a.SEAS_CD||'","'|| > a.RETIRE_DATE||'","'|| > a.USERID||'","'|| > a.UPDATE_DATE||'","'|| > a.ADD_DATE||'","'|| > a.INDICATOR_CD > FROMl a, > b, > c, > d, -- http://www.freelists.org/webpage/oracle-l