CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
priyam agrawal
priyam agrawal

Reputation: 1

Populating tables in SQL Developer using data from a file

I have a txt file containing a table with two columns student ID and GPA. I want to create a similar table in Oracle SQL developer. Is there some way to copy this data directly into SQL developer

Upvotes: 0

Views: 742

Answers (2)

eureka
eureka

Reputation: 529

If you are looking for a simple GUI method, you can connect to a db, right click on "Tables", "import data..." and use the Data Import Wizard. Select the correct options (csv/delimited, tableName, cloumnsToImport...) and click "Finish".

Sorry, I cant post pics yet see the example screenshot here: https://i.sstatic.net/S7HFx.png

Upvotes: 1

54l3d
54l3d

Reputation: 3973

You can create external table with that file, then copy the external table into a new internal table (usual table), here is a full example:

External Tables Concepts Then go to:

Example: Creating and Loading an External Table Using ORACLE_LOADER

Upvotes: 0

Related Questions