O'Reilly logo

Oracle SQL Developer by Ajith Narayanan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required