Home » SQL & PL/SQL » SQL & PL/SQL » How Can I pain the 'tab' in a file
How Can I pain the 'tab' in a file [message #320362] Wed, 14 May 2008 17:29 Go to next message
gecs
Messages: 5
Registered: December 2007
Location: Lima
Junior Member

Hi everybody. I am generating reports in files with SPOOL command, but I don't know how to put the 'tab' character in file. Please if someone knows about it..help me!!!!

I want that file looks:
--------------------------------
Column1(tab)Column2(tab)Column3
Column1(tab)Column2(tab)Column3
Column1(tab)Column2(tab)Column3
Column1(tab)Column2(tab)Column3
-------------------------------



where:
(tab) means tabulation, TAB character ( in java is '\t')

I know that tab is equal 8 spaces ' ', but I don't know that, beacuse there's a difference.
Re: How Can I pain the 'tab' in a file [message #320363 is a reply to message #320362] Wed, 14 May 2008 17:33 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
CHR(9) is the decimal value for a horizontal tab; as opposed to a vertical tab CHR(11).
icon14.gif  Re: How Can I pain the 'tab' in a file [message #320364 is a reply to message #320363] Wed, 14 May 2008 17:46 Go to previous message
gecs
Messages: 5
Registered: December 2007
Location: Lima
Junior Member

Thanks, anacedent!!! (y)
Previous Topic: Concatenating the results
Next Topic: SQL query question
Goto Forum:
  


Current Time: Thu Dec 08 10:16:20 CST 2016

Total time taken to generate the page: 0.08592 seconds