Import data from Excel using PLSQL

How to import data prepared in Excel into an Oracle table using PLSQL Developer

Use PLSQL Developer to import the data prepared in Excel into the Oracle table in the following steps:

When preparing data in Excel, you can use the following techniques: In the Excel document, set the first column to an empty column, and arrange subsequent columns in order according to the fields and types of the data table to be imported (to facilitate import).

In PLSQL Developer, after logging in, find the database table to which data needs to be imported. Right-click the table name and select the "Edit Data" option to enter the Edit Table Data dialog box (similar to the telescope icon).

3.copy the data records in the Excel table and paste the data into the table columns displayed by PLSQL Developer in step 2.

4. Click the check button in PLSQL Developer to post, and then click the commit button to submit.

How does oracle database use the text importer of PLSQL to import the contents of the excel table into the database

1. Open the file you want to import, as shown in the picture. It needs to be in TXT or CSV format. If not, just change the suffix directly.

2. If there is a situation where the three columns in the picture are not divided into columns, you need to proceed in several steps.

step1: Change the field count to 3,;

step2: Each time you select a field, please select it from the drop-down menu where the arrow points

A total of field1-3 needs to be changed

The rendering is:

3. Just specify the already built table TABLE that you want to import

as the picture shows,

1》Click "To Orale data"

2》Owner: that is, the user name for your database login;

Table: Fill in the name of the table you created TABLE

3》Specify the field name and field type for each field

4. After these checks are correct, just click Import~

However, the text importer is only limited to importing a small amount of data. If the data is large, it will easily get stuck. This requires the use of batch processing. Please contact us if you need more information~~

The above is the detailed content of Import data from Excel using PLSQL. For more information, please follow other related articles on the PHP Chinese website!