Once Oracle SQL developer is installed you can open this project and to the changes you want. If you want to use this structure of database you just have to run the Database creation scritpt in your ...

Prior to the release of SQL Developer 1.0, which was formerly known as Project Raptor, Oracle didn’t have its own visual database development tool—only the character-based SQL Plus.

If you have installed Oracle XE, it seems to know about this. As shown below, add a connection name (I chose "XE"), and the username and password of the Oracle XE account that you created for yourself ...

Oracle Developer Tools for VS Code - enables Visual Studio Code developers to connect to Oracle Database and Oracle Autonomous Database, edit SQL and PL/SQL with autocomplete, Intellisense, ...