and this video will look at how to download and install oracle sql developer on windows system
now let's get started so first we'll download oracle sql developer so for
that let's open a chrome browser and here in the search bar search for sql developer
download so once you search for sql developer download and the first search result you
will see this oracle sql developer official website so just click on it
so here in the next page you will see this the sql developer download page where i can see this
four wasn't one which which was built on february 22nd 2021
and here you can see the support for windows 64-bit windows 32-bit mac os
linux and other platform and we're gonna install on windows 64-bit so just click on this download
so in the next page it will ask you to login into oracle account so if you
don't have oracle accounts so here you have this create account so click on it
so in the next page you have to fill up all this information email address password country all
this details and you can sign up for oracle account but i already have oracle accounts so
let's close this and let's login with my oracle account so once you sign in it will automatically
start download for you which will take a while and will wait till the download is completed
so it's look like our sql developer is downloaded so let's go to download folder
so here you can see the sql developer zip file so let's extract it so for
that let's right click on this and say extract here extric file
and it will extract inside the sql developer 24.1 and say okay so our sql developer zip file is
unzip and you can see this file folder is created so the sql developer is a portable
software meaning you don't need to install you can just simply run it but it is advisable you
you copy the sql developer into your driver the window is installed so let's copy this
and go to c drive and go to program files and let's copy here
and say continue
in case if you have this windows user which does not have access to copy this file into c
drive you can place this sql developer on different drive and you can run it so now our sql
developer is copied now let's go inside this and here you can see this exe file so let's create the
shortcuts for sql developers so right click on this one go to send to and send to desktop
so here you can see the sql developer shortcut is created on the desktop so for opening the sql
developer so simply just double click on it so this will launch as oracle sql developer for you
now say no say okay and let's maximize this so it is loading this page
so here by default it has detected this article which is installed on my system so now let's
uh connect to this oracle database so just you have to click on this so which will create this
connection for you so let's enter the password and say okay so i connected to my local database
so what happened like it has detected this dns entry and from there it is allow me to you know
connect to this oracle account so now let's create the new connection so for that right click on
oracle connection and say new connection so here let's type the name so i say
uh local and the authentication default enter the user and password will ask while uh connecting to
database so here i'm using localhost so let it be localhost then port is default1521 it's the same
for my database and for sid xe so in your case if probably you have to change this host name port
nsid and now let's test this connection let's put the password and say test so it says successful
and say save so my the connection is created now let's connect to this and enter the password
so i connected to local as well which is the same database but i created the different connection
so for this connection we use this uh the basic uh method for connecting this oracle connection but
you can use this tns entry as well so now let's create the tns entry for this oracle database so
let's go to this folder is my oracle is installed so i go to this oracle exe app oracle product then
this one then server then network and then admin and here you can that's dns names to
torah so let's open this so here you can see this already have this xe on my dns url let's copy this
and let's paste somewhere here and let's say xe then say local and let's put here this local host
and the port is one five two one the default and the service name is xe let's save this
so now let's create this uh the oracle connection using tns so right click on this one
say new connection and give this x e local and go with default x e
password then select this tns so once you select the tns here you can see this
xc local and let's test this so it says success let's save and say connect and say xe okay
so i connected to the same database using this third connection so here you can see this three
all three connections are active and if you want to you know open this uh worksheet so just
here you have the sql and you say xd local you just click on it it will open this new tab for you
so where you can write your query so here let's write the query so i say select stuff from
emp of the cmp table and select all so here you have this
triangle a green triangle so click on this one
so here you can see the result the employee
number name all those columns of my table so now let's go to any of the database
and here you can see this the table views indexes packages all this database object so now let's
expand this table so here you have this emp table so if you double click on this table
so it will open this the table in the first tab you can see all this column of my tables so if
you go to the data you can see the data and then you have this model constraint
so in the constraint what we have is
let's see so we have this constraint and if you go to the last one the sql
so which will give you this the create statement for your table so you here you can say create
table then your schema name then table name all this the indexes as well so if you want to
disconnect from this database so just right click on this one and say disconnect
so you are disconnected from this one so if you want to delete this connection so right click
on this one and say delete and say yes so your connection is deleted yeah that's all for this
oracle sql developer installation process hope this video will help you to
run the sql developer and create the connection for your
oracle database and thank you for watching this video and see you in the next video