Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Loader
- Thread starter Shobin
- Start date
- Thread starter
- #3
- Thread starter
- #5
Well, i'm going to try to explain better... <br>
I've a file that has a script which loads the data from the file to a table, one of the fields from my table must be updated with a certain date passed as parameter, this script is processed by SQL LOADER . Can i pass a parameter into this script?!
I've a file that has a script which loads the data from the file to a table, one of the fields from my table must be updated with a certain date passed as parameter, this script is processed by SQL LOADER . Can i pass a parameter into this script?!
I don't know of a way to pass a parameter like that to SQLLDR.<br>
<br>
It should be fairly easy to write a perl script that work go though your data file and update the field you need changing. Give me a few lines of your data file, tell me which field needs changing and I'll write you a pl that should do the job.<br>
<br>
Mike<br>
<br>
It should be fairly easy to write a perl script that work go though your data file and update the field you need changing. Give me a few lines of your data file, tell me which field needs changing and I'll write you a pl that should do the job.<br>
<br>
Mike<br>
- Thread starter
- #7
- Status