PL / SQL Developer is a dedicated to the development, testing, debugging and optimizing Oracle PL / SQL stored program units, integrated development environment such as triggers, stored procedures, functions, and packages.
Data in a single file is small (less than 10w line), and structure of the destination table already exists, you can use a plsql developer tools excel simple the copy Paste operation import oracle database. Specific mode of operation is as follows:
I want to import the table are the job the log table job_log, create a table job_log first
Data in a single file is small (less than 10w line), and structure of the destination table already exists, you can use a plsql developer tools excel simple the copy Paste operation import oracle database. Specific mode of operation is as follows:
I want to import the table are the job the log table job_log, create a table job_log first
create table JOB_LOG is
(
DATE DATE not null,
TYPE VARCHAR2 (100) not null,
Task VARCHAR2 (2550) not null,
Error VARCHAR2 (4000) not null
)
tablespace test;
(
DATE DATE not null,
TYPE VARCHAR2 (100) not null,
Task VARCHAR2 (2550) not null,
Error VARCHAR2 (4000) not null
)
tablespace test;
In plsql developer SQL window where input select * from job_log for update, in which the test is to import Oracle data table name;
Execute the query (by clicking on the button or shortcut F8 can be achieved);
Lock button, click the query results above query to the content being edited.
Copy (Ctrl + C) from an Excel data table you want to import Oracle data, if it is a single-column data import, you can press the plsql developer query results above the Add (+) button, so that the data table is add data, and then mouse-click on the name of the column in plsql developer, and finally use the shortcut keys ctrl + v to complete the data import operation, and click Submit plsql developer (check mark) "button to submit the changes.
Import all columns, the first column of the first excel table is set to a null value, select copy column with null values ??+ all the data, and then point PL / SQL Developer in an increase (+), and click the Edit line front of the asterisk (*) such that the entire row of data in the selected state, the final paste the data import.
If you the listed import data, you will need the completion of the column-by-column, first select the copy you want to import the data, and then increase (+) and click to edit the name of the column, the entire column of data in the selected state, the final paste data Import.
PLSQL Developer to perform data import and export operations of the main problems is the case of the large amount of data on Chinese data may be wrong, it is estimated that will receive the data table type is defined as the type of nvarchar2 better.In addition, this method requires manual more involved, can not achieve the effect of automatically imported.
This article comes from databaseskill.com blog, reproduced, please indicate the source:
PL / SQL Developer is a dedicated to the development, testing, debugging and optimizing Oracle PL / SQL stored program units, integrated development environment such as triggers, stored procedures, functions, and packages.
Data in a single file is small (less than 10w line), and structure of the destination table already exists, you can use a plsql developer tools excel simple the copy Paste operation import oracle database. Specific mode of operation is as follows:
I want to import the table are the job the log table job_log, create a table job_log first
Data in a single file is small (less than 10w line), and structure of the destination table already exists, you can use a plsql developer tools excel simple the copy Paste operation import oracle database. Specific mode of operation is as follows:
I want to import the table are the job the log table job_log, create a table job_log first
create table JOB_LOG is
(
DATE DATE not null,
TYPE VARCHAR2 (100) not null,
Task VARCHAR2 (2550) not null,
Error VARCHAR2 (4000) not null
)
tablespace test;
(
DATE DATE not null,
TYPE VARCHAR2 (100) not null,
Task VARCHAR2 (2550) not null,
Error VARCHAR2 (4000) not null
)
tablespace test;
In plsql developer SQL window where input select * from job_log for update, in which the test is to import Oracle data table name;
Execute the query (by clicking on the button or shortcut F8 can be achieved);
Lock button, click the query results above query to the content being edited.
Copy (Ctrl + C) from an Excel data table you want to import Oracle data, if it is a single-column data import, you can press the plsql developer query results above the Add (+) button, so that the data table is add data, and then mouse-click on the name of the column in plsql developer, and finally use the shortcut keys ctrl + v to complete the data import operation, and click Submit plsql developer (check mark) "button to submit the changes.
Import all columns, the first column of the first excel table is set to a null value, select copy column with null values ??+ all the data, and then point PL / SQL Developer in an increase (+), and click the Edit line front of the asterisk (*) such that the entire row of data in the selected state, the final paste the data import.
If you the listed import data, you will need the completion of the column-by-column, first select the copy you want to import the data, and then increase (+) and click to edit the name of the column, the entire column of data in the selected state, the final paste data Import.
PLSQL Developer to perform data import and export operations of the main problems is the case of the large amount of data on Chinese data may be wrong, it is estimated that will receive the data table type is defined as the type of nvarchar2 better.In addition, this method requires manual more involved, can not achieve the effect of automatically imported.
0 comments