How to Import Data into Oracle Database?

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. Oracle database contains data in the form of tables in the form of rows and columns. In this article, we will see how to import data into the Oracle database.

Here is few step through which we can import our files data into oracle database in the form of rows and columns.

Step 1: Log in to your oracle database.

Step 2: Click on option Utilities -> Data Load / Unload->Load.

Step 3: You can load Load Text Data, Spreadsheet Data, XML Data. Click on the option Load text data to load text file which is in CSV(comma separated value) format as shown above.

Step 4: Select New table as we want to load the data into new table and select upload file option. Click on the option next.

Step 5: Select the file you want to import. Here selected file is  student_info.txt. This file contain seven rows of students information. Put separator ( ,)  as our file is comma separated. Click on option next.

Step 6: Give a name to your table in which data is going to be stored. Click on option next then select customizing option as you want and click on next then your data is successfully uploaded in database.

Step 7: You can also check through sql command. 

Query:

Select * from gfg_demo_table

Source: geeksforgeeks.org