Recently, data is being input into the Oracle database. The number of tables in the database is large, and there are many data records in some tables. Some have fewer data records. At the beginning, a few tables are input into the database, I found that the data volume in the table was too large. I was wondering if I could use one-time data input. I found it online and tried PL/SQL limit 8.0. It was very convenient.
The PLSQL developer tool is the most commonly used tool by famous oracle DBAs.
When a single file is small (less than 100000 rows) and the target table structure already exists-for excel, the maximum behavior of an Excel file is 65536, you can select all data copies and then use the PLSQL developer tool.
1. Enter the select * from table name for update in the SQL window of PLSQL developer;
2. Press F8.
3. open the lock (edit data), click the plus sign, click the column header in the first column, select all columns, paste them, and submit the commit statement.
The following describes the possible errors and actual problems:
When creating a table field in an Oracle database, it cannot contain (M), X, or other characters. Otherwise, data cannot be commit due to errors such as invalid character or missing comma; (because the field name was set to enterprise (count)/output value (million RMB) during data input last time, an error occurred. After searching for the field for a long time, no related prompts were returned. The error was finally found out, I will never make similar mistakes again)