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
Printable View
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
No, AFAIK ( i think u r trying something like comparing data & then wana load, & that using SQLLDR ? )
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
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 !
He's not.
Well, i did see in his post mentioning 8.x..
thas why i said, "if u were .."
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.
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. :rolleyes:Quote:
Originally posted by abhaysk
If u were on 9.x.. ext tables was ur ans !
apprnly he dnt gv a crp!Quote:
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. :rolleyes: