Create a local database in SQL

Question

After successive failures, I come here to ask for help in desperation.

All I need, is to be able to create and host locally a database, that I can later connect to via SQLDeveloper (preferably, but it can be any other program. That's what my professor recommended us using this year).

I've googled this prior to asking this question, but all I can find is tutorials on how to connect to the database. I first need to create one, in order to connect to it (or at least that's how I understood the concept).

Please give any suggestions, links to tutorials, programs that I need or questions regarding what i actually want all of this for.

Go to your mysql console and just type: CREATE DATABASE databasename; — Parth Soni
– Parth Soni, Commented Nov 9, 2020 at 14:10
SQL Developer is designed for Oracle databases. If it can connect to MySQL, it's possibly just to aid in data migrations to Oracle. Are you positively sure you got all the names right? — Álvaro González
– Álvaro González, Commented Nov 9, 2020 at 14:19
Then you can remove the <mysql> tag and instead add an <oracle> tag. — jarlh
– jarlh, Commented Nov 9, 2020 at 14:30

EdStevens · Accepted Answer · 2020-11-09 16:43:39Z

3

To create a database you will first need to download and install the software, from here.

Since this is for school, I'd guess that the 18c Express Edition would be sufficient. The specific link is on the page for which I provided a link. When you drill down to the specific database you want (XE, Enterprise Edition, etc) there will also be a link to the installation guide.

Every oracle installation I've seen also offers, as part of the installation dialog, an option to also create a database. But note that creating a database is logically separate from installing the software. You can also choose to install software only, then later run DBCA (Database Creation Assistant) to create a database.

As you suspect, SQL Dev is just a client. It is not the database, and doesn't create a database when it is installed.

answered Nov 9, 2020 at 16:43

EdStevens

3,9203 gold badges12 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create a local database in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related