There are three data formats of the same text files, each data in a text is four columns: time X Y Z axes, each text files in the "time" the column is the same, now take these three text file data imported into a database table, table structure is the form below, excuse me what method can be implemented? I am a novice, troublesome everybody a great god solve, thank you!
In the structure of database tables is such:
Time 1 X 1 Y Z axes X Y Z axis 2 2 3 X 3 Y and Z axes

CodePudding user response:

The three files were imported into the first three table, and then processing to your business list;

CodePudding user response:

Oh oh ~ ~ I will try, thank you
Do you have a one-time three files (three files will not be merged into one) method at the same time into the format in the table above

CodePudding user response:

The three files into three tables respectively, in the time field associated query,

CodePudding user response:

refer to the second floor qq_37490199 response:

oh oh ~ ~ I will try, thank you
Do you have a one-time three files (three files will not be merged into one) and imported into the format in the table above method?

This is difficult, there is a column matching process according to the time,

CodePudding user response:

refer to the second floor qq_37490199 response:

oh oh ~ ~ I will try, thank you
Do you have a one-time three files (three files will not be merged into one) and imported into the format in the table above method?

You can, write a shell script,
@ txt1. TXT
@ txt2. TXT
@ txt3. TXT
.
Will three TXT file is loaded into the database table,

CodePudding user response:

It is recommended to use ORACLE's external tables, is to create a table in the ORACLE, points to the operating system, the text file is actually in the text data query, three files to create three tables respectively,