The entire file is a column in a excel list, but there are nearly one hundred million rows, how will the large amounts of data into the oracle? I need to ask the data of the first few digits in a row! Thank you very much!

CodePudding user response:

File is the CSV format, said wrong

CodePudding user response:

reference 1st floor qq_33431747 response:

file is CSV format, said wrong

Use SQLldr import, function was used to extract

CodePudding user response:

_ to learning turn reference 2 floor response:

Quote: refer to 1st floor qq_33431747 response:

file is CSV format, said wrong

Use SQLldr import and use function to extract

Thank you very much! Go back to try ￣ ￣) sigma

CodePudding user response:

CSV format file to use sqldeveloper can be directly imported into the can, then according to the requirements to write SQL language can be solved

CodePudding user response:

reference 4 floor Kevin_ora response:

CSV format file to use sqldeveloper can be directly imported into the can, then according to the demand to write SQL language can solve

File has one hundred million lines, can also use sqldeveloper import?