-
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
-
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"
-
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
-
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.
-
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"
-
-
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"
-
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
-
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?
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|