Results 1 to 8 of 8

Thread: SQL 'Unloader'

  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: SQL 'Unloader'

    What process would you use for a SQL 'Unloader', basically outputting the contents of a table into a flat file?

    -Chuck

  2. #2
    Join Date
    Dec 2003
    Posts
    1,074

    to clarify

    this would need to be something that could be set up in a Scheduler, no manual intervention. Is UTL_FILE the only approach?

    Thanks,
    Chuck

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQL*Plus or PERL
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  4. #4
    Join Date
    Dec 2003
    Posts
    1,074
    Something in SQL Plus? I'm not sure how I could set that up to run by a scheduler.

    PERL makes sense, but what utility would be used?

    -Chuck

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://www.cybcon.com/~jkstill/util/zips/dump.sql

    -- dump.sql - jared still
    -- jkstill@cybcon.com
    --
    -- dump a table to a comma delimited ascii file
    -- only drawback is line length is likely to be padded with
    -- quite a few spaces if the 'set trimspool on' option is
    -- not in your version of SQLPLUS
    --
    -- also builds a control file and a parameter file for SQL*LOADER
    --
    -- 08/28/2000 - use defined variables for quotes and commas
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    On windoze, At or Winat will schedule a command. On *nix there will be equivalent (probably superior!) commands.

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  7. #7
    Join Date
    Dec 2003
    Posts
    1,074
    LINUX, if that helps.
    -cf

  8. #8
    Join Date
    Feb 2003
    Posts
    45
    SQLplus - SQL & SPOOL

    OR

    A custom Perl Script

    = Scheduling ==>

    Windows - Windows Scheduler
    Unix - Cron

    Mix N'match any of the above and you would have a solution ...

Posting Permissions

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