Home » RDBMS Server » Server Utilities » File name validation
File name validation [message #230318] Wed, 11 April 2007 09:21 Go to next message
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 #230320 is a reply to message #230318] Wed, 11 April 2007 09:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please Search before posting.
http://www.orafaq.com/forum/t/26733/0/
Re: File name validation [message #230326 is a reply to message #230320] Wed, 11 April 2007 09:36 Go to previous messageGo to next message
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?
Re: File name validation [message #230329 is a reply to message #230326] Wed, 11 April 2007 09:43 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you atleast read the full thread?
There is an example with windows. You just echo your entries.
Previous Topic: Data Pump import
Next Topic: public synonyms are not getting imported
Goto Forum:
  


Current Time: Fri Dec 02 22:41:37 CST 2016

Total time taken to generate the page: 0.06213 seconds