From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Creating a connection to the database

Creating a connection to the database - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Creating a connection to the database

“

- [Instructor] Before we can start using SQL Developer to write and execute our SQL queries, we first have to configure a new connection to our Oracle database. That's because Oracle SQL Developer is the program or application we use to execute our SQL queries, but it still needs to connect to an Oracle database which contains the data we wish to query. Oracle SQL Developer supports the ability to create and configure multiple connections to multiple Oracle databases. However, for our course we'll only be using a single connection to the HR or human resources schema that comes pre loaded in the Oracle demo virtual machine. So, how to create a new connection? Easily. We'll use the Connections pane on the left side of the screen and either click on the green plus button or right click on connections and choose new connection. In the next screen, we'll need to provide our connection details. For example, we need to give a name for our connection. HR suits our use case as we will be…

Contents