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

Home -> Community -> Usenet -> c.d.o.tools -> How to generate a "tab" value in SQL*Plus

How to generate a "tab" value in SQL*Plus

From: Susie Grace <hlng_at_usa.net>
Date: Tue, 19 Sep 2000 23:18:38 GMT
Message-ID: <8q8s7s$qn9$1@nnrp1.deja.com> 






I want to generate a "tab" between columns in SQL*Plus, in order to
spool a flat file that can be imported into Excel.



What happens frequently is that commas and other keyboard values are
commonly typed in column values; this can confuse Excel as to what is
the actual column separator.



I wish to do a Select column1, "tab", column2, "tab", and so forth,
replacing "tab" with the equivalent of what translates into a tab.



Thanks in advance.




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Tue Sep 19 2000 - 18:18:38 CDT












Original text of this message













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