Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*PLUS REPORT

SQL*PLUS REPORT

From: miguel <jmiguel_at_cet.pt>
Date: 1997/12/11
Message-ID: <01bd062a$36e4cf80$0a0a2c0a@jmiguel.cet.pt>#1/1

Hi,

I have table test(a,b,c)
I have a scrip like this:

   SET TERMOUT OF
   SET PAGESIZE 0
   SET HEADING OFF
   SET FEEDBACK OFF
   SPOOL TEST1.CSV
   SELECT a || ´,´ || b || ´,´ || c FROM test;    SPOOL OFF The TEST1.CSV look like this:

   1,2,3
   2,3,4
   3,4,3
   2,3,4

   input truncate to 9 characters

How do i avoid this last line("input truncate to 9 characters")? Thanks
MIGUEL Received on Thu Dec 11 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US