| File name validation [message #230318] |
Wed, 11 April 2007 09:21  |
jra_kumar
Messages: 7
Registered: April 2007
Location: India
|
Junior Member |
|
|
Hi,
I have to upload the text file into table using sql loader.
I'm using like this :
sqlldr userid=scott/tiger control=test.ctl data=site1_110407.csv
It's working fine. Now, I have the another table which store the values like "site1" as one column and "110407" as another column.
But this file name doesn't present inside the file. So, I don't know how to store this file name into that table?
Please tell me the idea to store the file name into the table?
|
|
|
|
|
|
| Re: File name validation [message #230326 is a reply to message #230320] |
Wed, 11 April 2007 09:36  |
jra_kumar
Messages: 7
Registered: April 2007
Location: India
|
Junior Member |
|
|
That's code in unix...Really I don't know unix or pearl, etc..
I want the same code in Windows. Plz, can you convert and reply as the windows bat file?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
