| update from file dbf [message #23401] |
Thu, 05 December 2002 10:18  |
eliza
Messages: 5
Registered: January 2002
|
Junior Member |
|
|
I just want to update information from dbf file to table of oracle from sql , how can i do this?
thank for any assitance...
|
|
|
|
| Re: update from file dbf [message #23404 is a reply to message #23401] |
Thu, 05 December 2002 11:43  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
I think you can read a dbf file using ODBC and then use the SQLPLUS "copy" command to access the dbf file. Youll essentially copy the contents of the dbf file into a staging table and then use SQL to synchronize the staging table with your main table. Alternately you can convert the dbf to text and then use utl_file or sqlloader or whatever to load the flat file.
txt2dbf, dbf2txt
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
