Re: tab delimiter

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Tue, 23 Oct 2001 16:12:40 +0200
Message-ID: <9r3tr7$cvr$1@wanadoo.fr>

try this, please:

v_out_line := 'Name' || CHR(9) || 'Adresse' ...

"Rob Zwartjes" <rzwartje_at_rob.home.nl> a écrit dans le message news: slrn9tapue.uaj.rzwartje_at_home.rob.nl...
> Hello,
>
> I am trying to make a TAB delimiter file from sql but with no succes.
> This is probably verry easy but not for me :) I tried the following:
> v_out_line := 'Name' || '\t' || 'Adress' || '\t' || ...
> But the the outcome was : Name\tAdress\t....
> Changing to '\\t' didn't work either. Also, wich I like most if it
> works' creating a variable like:
> FS varchar2(1);
> FS := char(9);
> v_out_line := 'Name' || FS || "Adress' || FS ...
> But now sql is complaining that 'FS := char(9)' is not the correct way
> of adressing it :(
> Skipping the variable part and putting it in the string like :
> v_out_line := 'Name' || char(9) || 'Adress' || char(9) || ...
> is not allowed.
>
> can somebody help me out here. Thanks in advance
>
> Rob Zwartjes
Received on Tue Oct 23 2001 - 09:12:40 CDT