update in SQL Loader
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 22

Thread: update in SQL Loader

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    update in SQL Loader

    Hi Friends,
    I am using oracle 8.1.7.4, solaris 2.8.
    We do a daily data load using SQL LOADER. Is it possible for me to get value from another table and load data using SQL LOADER.
    Can u please help me on this

    Regards
    anandkl
    anandkl

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    No, AFAIK ( i think u r trying something like comparing data & then wana load, & that using SQLLDR ? )
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    Yes, based on a key column, i will be comparing and for all matching keys, i select a column value from other table and will load data for that column

    Is there a way i can do that in SQL LOADER.

    regards
    anandk
    anandkl

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If I understand you, you could generate the loader control file from whatever table(s) in the db and write it with UTL_FILE.
    i.e. two steps, SQLplus then SQLloader.

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    If u were on 9.x.. ext tables was ur ans !
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    He's not.

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Well, i did see in his post mentioning 8.x..

    thas why i said, "if u were .."
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you were using MS Access, you could click a few checkboxes and it would be done. However, since you're not, you might look at an INSTEAD OF trigger, although you will have to load in conventional mode.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by abhaysk
    If u were on 9.x.. ext tables was ur ans !
    Abhay, when will you finaly get your keyboard repaired? It is missing many characters (in particular vowels), haven't you noticed? Anything you type on it is hardly readable.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by jmodic
    Abhay, when will you finaly get your keyboard repaired? It is missing many characters (in particular vowels), haven't you noticed? Anything you type on it is hardly readable.
    apprnly he dnt gv a crp!
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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