Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2008
    Posts
    99

    Unanswered: exporting excell automatically

    Hi,
    is there a way to export data in excell format in oracle? In mssql server I was creating DTS for this kind of actions
    Kind Regards

  2. #2
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    execute a spool from sqlplus con column separator equal to ';'. The suffix of the created file should be .csv so when you will open this file, it will be open directly con excel.

  3. #3
    Join Date
    Dec 2008
    Posts
    99
    Quote Originally Posted by ducasio
    execute a spool from sqlplus con column separator equal to ';'. The suffix of the created file should be .csv so when you will open this file, it will be open directly con excel.
    Actually it's gonna be a weekly report.I think there is not a DTS counterpart in Oracle.or how do you handle such kind of requests?

    Thanks

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    ducasio was saying somehting like this:
    PHP Code:
    duck@db01select 1,2,3 from dual;

             
    1          2          3
    ---------- ---------- ----------
             
    1          2          3

    duck
    @db01set colsep ","
    duck@db01select 1,2,3 from dual;

             
    1,         2,         3
    ----------,----------,----------
             
    1,         2,         
    with comma-dilimited you can spool the output to a .csv file which
    can be opened by outlook.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Use HTML

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  6. #6
    Join Date
    Dec 2008
    Posts
    99
    Quote Originally Posted by LKBrwn_DBA
    Hi,
    Thanks,is there a way to get it done automatically?
    Kind Regards

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Schedule script

    You write a script(s) and schedule it.
    .
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Dec 2008
    Posts
    99
    Quote Originally Posted by LKBrwn_DBA
    You write a script(s) and schedule it.
    .
    Hi,
    if you suggest a link I can take a look.I didnot schedule a report on oracle before. ? are you telling oracle scheduled jobs?
    Thanks

  9. #9
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Cron/winDoze scheduler/EM

    Write a script that:
    1) executes sqlplus and generate a file with the report.
    2) ftp/copy the file to the target server/path from where it's accesible by excel

    Schedule the execution of the script with cron(unix) or winDoze scheduler or Oracle Enterprise Manager.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  10. #10
    Join Date
    Dec 2008
    Posts
    59
    I am not sure about that but i think it would help you.
    save excel file in csv format and write control file to load data into Oracle DB using sqlloader

Posting Permissions

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