To be in a perfect condition to work with your oracle database efficiently, you must create some database connections, so that you can view and work with database objects, use the SQL Worksheet, and use other interesting features.

Take note though – If the Oracle Home on your system is for Release 11.2.0.2 or is an earlier version, you cannot be able to use the “Create Local Connections” feature of SQL Developer to auto-generate local connections. (The Oracle Home associated with Express Edition is Release 11.2.0.2.) Instead, you must create individual database connections manually, as explained in this section.

You can always create database connections to Oracle database instances and the local Express Edition database on other systems. If you …

Read More →