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

Thread: about tab delimiters VERY URGENT

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    Hi folks
    I want a comma or tab or || delimiter file output for the data
    generated thro a querry from two tables.Qry is simple sql querry
    and i need to use this output to import into excel spread sheet
    so guys help me on this its very urgent
    thanks
    SAT
    sat

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    why not use:
    select col1 || ','|| col2...
    from tab1, tab2
    ...

  3. #3
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    hi sysdba,
    can i import this into excel spread sheet .
    sat

  4. #4
    Join Date
    Jun 2000
    Posts
    417
    if you know how to import comma separated files (csv) sure.

  5. #5
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    HI sysdba,
    THANKS a lot..i did imported into
    excel worksheet .Now how can i trim the blank spaces
    in columns which are i mean if datalength is varchar2(200)
    and only few letters were occupied how can we trim this
    thanks again
    sat
    sat

  6. #6
    Join Date
    Sep 2000
    Posts
    31

    Smile delimiters VERY URGENT

    Hi there,
    i often use msaccess to get data from oracle tables and import access tables into excel files. By this way, you don't have to worry about sql code writting.
    jn

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    select rtrim(col1) || ',' || rtrim(col2) ...
    Jeff Hunter

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