Oracle SQL Developer

Importing data

Using SQL Developer, you can also import data into tables. The most common approach is running a well-formed (syntactically correct) script file of INSERT statements. The Import Data wizard is available from the context menu of existing tables and on the context menu of the Tables node, where you can import data and create the table in a one-step operation. The import wizard allows you to import data from a delimited format file or a Microsoft Excel XLS file. In this section, we'll look at three of the supported SQL Developer Data Export file formats.

Importing data from SQL script files

When importing data into tables from a file, the structure of the file, whether it is SQL or XLS, determines how the import works. For an SQL script ...