All language subtitles for [SubtitleTools.com] Setting Up The SQL Developer - Learning Oracle 12c [Video]

In this lesson, we want to
do a little initial setup

and configuration
for SQL Developer.

Now, SQL Developer is really
one of the primary tools

that we use to connect
to an Oracle database.

So anytime we have a
database that we've created,

we need tools to connect to
that database and do work with.

One of those tools is SQL*Plus.

And this is an older tool
that's not really deprecated,

and, indeed, it's used by
a lot of DBAs still today

to do a lot of
administration tasks.

But Oracle sort of sees SQL
Developer as being the eventual

replacement for SQL*Plus So
SQL Developer sort of the tool

of choice for both DBAs and
developers depending on what

type of work that you're doing.

So to get this
initial setup, we want

to put a shortcut
on the desktop,

here, so that we can make it
easy to go to SQL Developer

and run it.

So I'm going to click this
shortcut, which is just the app

directory in this E drive.

So what we want to
do here is drill down

to the Oracle software
and find SQL Developer.

Product directory,
12.1.0, dbhome.1.

And now at this point, we're
in the Oracle home directory.

So this is the home directory
that contains all the Oracle

software.

So I'm going to go
down to SQL Developer

and there we have
sqldeveloper.exe.

Now, this is on the
Windows platform.

If you had this
in Linux or Unix,

you would just see sqldeveloper
or sqldeveloper.sh,

as we see here.

And those are just
executable files

that will start
the Java libraries

necessary to run SQL Developer.

So I'm going to right click
here, Create Shortcut, and drag

that shortcut to the desktop.

So now we have SQL Developer
shortcut on the desktop.

Let's click to start it.

And SQL Developer starts.

Now depending on what version
of SQL Developer that you use,

you may have a different
path to get to this point.

You may be prompted
for a java.exe,

executable and that's in
order to run the SQL Developer

software.

So while we're setting
up SQL Developer,

if you receive that prompt
and you can't go any further,

go back into the
Oracle home directory.

Let's come up here and
do a search for java.exe.

So in the Oracle home
directory, either

in jdk bin or jdk jre bin,
we're going to have a java.exe.

So either one of those can be
used to start SQL Developer.

Now, that prompt only
happens the first time

you start SQL Developer.

And depending on whether you
download it from the Oracle

website or that you use
the included software,

you may or may not
get that prompt.

All right, so in order
to use SQL Developer,

we need to connect to a.

Database and in order to
connect to the database,

we have to set up a connection.

So I'm going to click
plus for new connection.

And we're going to
set system@orcl.

A system is a user name,
orcl Is the database.

Put in the password.

Click Save Password.

We need to put in the host
name here, which in my case,

is this.

You change it to the host
name of your choosing.

The SID is going to
be the database name.

And we click Test.

Get the successful prompt
down here and connect.

Let's change the connection
name, it doesn't like that.

System_orcl.

Test again and connect.

Now let's click
the plus again, we

want to set up
another connection.

That will be scott_orcl,
user name's scott,

and the password for
this will be tiger.

This is the old
Scott Tiger account

that includes a few
example schemas and tables

that we can use again.

We set this to our host
name and database name.

Test, connect, and now we
have two connections-- scott

and system.