Afrikaans
Akan
Albanian
Amharic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Ewe
Faroese
Filipino
Finnish
French
Frisian
Ga
Galician
Georgian
German
Greek
Guarani
Gujarati
Haitian Creole
Hausa
Hawaiian
Hebrew
Hindi
Hmong
Hungarian
Icelandic
Igbo
Indonesian
Interlingua
Irish
Italian
Japanese
Javanese
Kannada
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kurdish (Soranรฎ)
Kyrgyz
Laothian
Latin
Latvian
Lingala
Lithuanian
Lozi
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Malayalam
Maltese
Maori
Marathi
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Nigerian Pidgin
Northern Sotho
Norwegian
Norwegian (Nynorsk)
Occitan
Oriya
Oromo
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Punjabi
Quechua
Romanian
Romansh
Runyakitara
Russian
Samoan
Scots Gaelic
Serbian
Serbo-Croatian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Spanish (Latin American)
Sundanese
Swahili
Swedish
Tajik
Tamil
Tatar
Telugu
Thai
Tigrinya
Tonga
Tshiluba
Tumbuka
Turkish
Turkmen
Twi
Uighur
Ukrainian
Urdu
Uzbek
Vietnamese
Welsh
Wolof
Xhosa
Yiddish
Yoruba
Zulu
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.
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.