Rob Zwartjes wrote:
>
> 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
Look at the CRH() function in SQL*Plus.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Tue Oct 23 2001 - 08:25:15 CDT
