Shulou(Shulou.com)06/01 Report--

Import the EXCEL table into the ORACLE database

First, establish a table

1. Create a table

two。 Query table

Select * from yy

II. Import program

Find the data to be imported in excel

two。 Save the data in excel as a text file (separated by tabs)

3. Select tools-- > text importer in pl*sql, select "Data from Textfile" in the window that appears, and then select "Open data file"

Select the text file with the saved data in the pop-up file selection box, and you will see the data to be imported displayed in data from textfile

4. Configure the following in configuration

Note: if the "Name in header" is not checked, the field name will also be imported into the database as a record, resulting in a data error (there is a title for the first row of the import, otherwise there is no need to select)

5. Click data to oracle, select the table that will import the data, and associate the fields in the text with the fields in the table in fields

6. Click the import button to import

7. View imported data

OK, and the data has been imported successfully.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.