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

Thread: Tab Delimited

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

    Does any one know how to generate TAB delimited files using sql.

    Thanks in advance
    Jagdish.

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    it worked fine for me if you just do something like this


    select column1 || '<insert tab here>' || column2 || '<insert tab here>' || column3 from table where condition;

    if that doesn't work for you for some reason, you could always delimit it with some other character like a comma, then search and replace the commas with tabs with a small script.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    You could use colsep in sqlplus:
    set colsep '<insert tab here>'

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