DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tab delimited

  1. #1
    Join Date
    Jul 2000
    Posts
    9
    Hi,

    Any one has any suggestion how to generate a TAB delimited file.

    Thanks
    GJ.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    try using the sql worksheet:
    select '234'||chr(9)||'234' from dual;

    you'll get a tab-delimited section. just cut & paste.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Oct 2000
    Posts
    123
    That is right. CHR() is a function will return the charactor with the ascii value of integer. U can add char(10) just after the "TAB" character to indicate the new line.

    go to [url]http://members.tripod.com/~plangford/index.html[/url]
    to see all the ascii table.

    Take care

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width