tab delimiter

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 - 08:18:47 CDT