Program is used to implement the data from the file is inserted into the new database, what is the great god ideas

CodePudding user response:

1, read the file content
2, the implementation of the insert statement,

CodePudding user response:

BCP in no way, try

CodePudding user response:

What is the data format? Amount of data?

CodePudding user response:

Want to see what is your file format,

CodePudding user response:

To convert the data files to EXCEL format, and then COPY directly to the table,

CodePudding user response:

Generate the.xls files, use the PSL - SQL tool odbc importer import the new table

CodePudding user response:

If the file format specification, can have a try PLS devloper - & gt; tools-> The text import table, file, give it a try, general data is can try! Hundreds of thousands of estimate is stuck!

CodePudding user response:

Add the basic syntax is as follows:
INSERT [INTO] the table or view name field list
VALUES data VALUES list

CodePudding user response:

Amount of data about, small amount of data, directly excel copy in good, large amount of data in SQL loader import

CodePudding user response:

Oracle EXTERNAL TABLE EXTERNAL TABLE can also,

CodePudding user response:

In PL/SQL or sqlloacder, oracl external table can also be to import, data pump IMPDP import data can do it,