How to Import Data in Oracle SQL Developer Web
Tags: beginners, sql, programming, tutorial
Published: 2022-06-21 15:02:05

Howdy coders! This blog post is going to cover **how you can create a new table in Oracle SQL Developer Web using imported data from .CSV file** 💪🏽 

If you haven't set up your *'Always Free' *Oracle Cloud account (it's literally *always free *LOL) and created a Database yet, [click here and follow the steps in this blog post before following this one.](https://laylacodes.hashnode.dev/creating-an-atp-database-with-oracle-sql-developer-web)

Let's get jiggy with it 😎


### Steps

#### Step 1) Sign In

Go to oracle.cloud.com and sign in! (Save your log-in info for quick access)


#### Step 2) Choose your Database

Click on `Autonomous Database` listed under Service Links. 

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vzc01iaocbe4y9v7ae08.png)
 
📌 *And if you can't find `Autonomous Database` in Service Links, type the name of your Database in the search-bar. * Like I did below:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/tf92ftlxh5l0qrcea17y.png)
 My Database name is 'beautifulsoop', so if I just type that in the search-bar, press Enter... my database will show up! 

So, now click the name of your Database & that'll take you directly to your `Autonomous Database Details` page that looks like this:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qkn9g5bj5baefuduwmjn.png)
 
#### Step 3) Click on `Database Actions`

#### Step 4) Click on `SQL`

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rm1495qm01ipdgj2utyu.png) 
📌 (Fun fact: you can bookmark this page to be able to refer back to your Database Launchpad **directly!**)

#### Step 5) Click the `...` 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/k96aj7j5xt81kohmckst.png)
 
And click `Data Loading` ► `Upload Data Into New Table`

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dsj40mmgwbvonjw6f8fv.png)
 
Then, *upload your file!* Notice how it automatically grabs column names to be created? 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hnekbkrybxhn07hu24i8.png)
 
Click `Next` to define your data types, a Primary Key, what can be Null, etc. 
Shown here: 
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mstgxunq2zdwb1r8ggfh.png)
 Click `Next` to review the details of your new table. Notice how it shows the *actual* DDL code that would be used to create the table and insert the data! It also shows you what cells from your spreadsheet file have been turned into column names.

See below:
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/1wa00jcbys307mp008kx.png)
 Follow the GIF below to see the whole process:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/x0ckfh229k05iu1kuc5g.gif)
 

Now, your table is created, and populated with all the data from the file you uploaded! **SO EASY, RIGHT?** 💪🏽 and now when you run the query `SELECT * FROM your_new_table_name_here;` --> the table you just created with all your file data will show up! 

See below:

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rok00343fqbdk2p9u7ta.png)
 

AND FIN - you just learned how to upload data into your database using Oracle SQL Developer Web! 😎  literally only takes 5 steps!

If you have any questions, don't hesitate to drop them in the comments below OR ping me on Twitter --> [@pilatesdev](https://twitter.com/pilatesdev)

🧡 see you in my next post