Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tab delimiter
On 23 Oct 2001 13:18:47 GMT, rzwartje_at_rob.home.nl (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
Could you post the full code instead of abstracts. Your last assertion definitely is incorrect. Aren't you mixing up sql and pl/sql. Could also post (what you should always do) post *exact* error messages other than 'Sql is complaining' and 'is not allowed'. You can't expect anyone to set up a case and reproduce your problem, I know for certain that if I reproduce your case, I won't run into any errors (except for the first attempt which is using Unix escape characters, which Oracle doesn't support)
Regards
Sybrand Bakker, Senior Oracle DBA Received on Tue Oct 23 2001 - 08:32:04 CDT