How to install SQL Developer on Windows 10 | Create Database connection using SQL Developer Tutorial

  Рет қаралды 32,962

REGex Software

REGex Software

2 жыл бұрын

In this video section we will discuss how to install SQL Developer on windows 10.
We will also discuss how to create database connection with Oracle SQL. Download SQL Developer is done in easy steps.
Things discussed in this video:
How to install oracle SQL developer on windows 10
How to create Database connection using SQL Developer
How to unlock HR schema in oracle 11g
First you need to install Oracle SQL Developer then for installing SQL developer extract the file and open the sqldeveloper folder then run the application.
Commands to unlock hr user in oracle 11g
1) alter user hr account unlock;
2) alter user hr identified by hr;
#SQLDeveloper #download #windows10 #OracleSQLDeveloper #tutorial

Пікірлер: 72
@mohammadkasim2205
@mohammadkasim2205 2 жыл бұрын
I hope everyone loved this video while they are working with SQL developer. Thanks!
@REGexSoftware
@REGexSoftware 2 жыл бұрын
You're welcome!
@bommanagayathri82
@bommanagayathri82 Жыл бұрын
I'm facing error while connecting ORA-01017 INVALID USERNAME/PASSWORD, Can you advise in cmd password is working but Sql developer notworking
@mohanavamsiperni7788
@mohanavamsiperni7788 Жыл бұрын
@@bommanagayathri82 Same problem here...Is that your query resolved
@anjalishukla2769
@anjalishukla2769 3 күн бұрын
one of the best video on sql developer in windows 10
@mihaigabriel03
@mihaigabriel03 Жыл бұрын
I swear on my life working on a oracle sql project u saved my life. Love you bro
@REGexSoftware
@REGexSoftware Жыл бұрын
Glad I could help
@nekeishapope5517
@nekeishapope5517 2 жыл бұрын
You sir owned my subscription! Thank you!
@ajayagarwal972
@ajayagarwal972 2 жыл бұрын
Simple installation with the complete guide & to unlock HR user
@vaishnavighatkeshwaram
@vaishnavighatkeshwaram 2 жыл бұрын
Thank you!it helped me👍
@adamsmith6373
@adamsmith6373 6 ай бұрын
Thank you for the video on unlock hr database in oracle database
@shwetangiverma1905
@shwetangiverma1905 Жыл бұрын
This is the best video on how to install sql developer on linux . Thank you man you are awesome
@saagar1111
@saagar1111 2 жыл бұрын
Thanks bro very very helpful
@MayuriFunde
@MayuriFunde 6 ай бұрын
Thank you so much, you saved the day🤗
@roshansingh3135
@roshansingh3135 Жыл бұрын
Thank you so much sir.
@kavyaseeramsetty4817
@kavyaseeramsetty4817 Жыл бұрын
Thanks! useful
@smitapawal9772
@smitapawal9772 2 жыл бұрын
Existing table mai archive hota hai ya nahi kaise dekhate hai...
@hkhsm359
@hkhsm359 2 жыл бұрын
thank you sir, its very helpful for me to install and create table
@REGexSoftware
@REGexSoftware 2 жыл бұрын
Thank You HK for such a positive response
@Rohit_Panchal53
@Rohit_Panchal53 Жыл бұрын
Very nice ❤️👍🏻
@kaverideore4099
@kaverideore4099 Жыл бұрын
Very useful
@sabasharikmaslat9235
@sabasharikmaslat9235 10 ай бұрын
After doing those steps still its showing user name is invalid what to do
@CouchCricket
@CouchCricket 7 ай бұрын
getting failure while connecting sql developer. Run SQL command line is connected but failure to connect sql. please assist Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=aR3CNaMBTp6c3qxXNQPUoQ==)
@Geethikareddy09
@Geethikareddy09 6 ай бұрын
Can i know whether the problem is resolved
@omkar2589
@omkar2589 2 жыл бұрын
3:26 Test failed: IO Error: The network adaptor could not establish the connection... Please help
@madhusudan0011
@madhusudan0011 2 жыл бұрын
Facing same issue
@venkateswarlumuttineni295
@venkateswarlumuttineni295 Жыл бұрын
Me also same issue please help
@mdenamulhaque7042
@mdenamulhaque7042 7 ай бұрын
same brother could you tell me how can I get solution of this problem
@ManiKandan-hx8dt
@ManiKandan-hx8dt Жыл бұрын
Nice
@mdenamulhaque7042
@mdenamulhaque7042 7 ай бұрын
sir please help me I am not getting connection
@aymazee336
@aymazee336 Жыл бұрын
can we not only use sys as sysdba? is it necessary to unlock hr and use it? For some reason, the hr one won't connect saying something about wrong password. I followed the video.
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey Ayma, You can follow along this video to unlock HR user as this HR user contain the dummy schema for the learning of Oracle SQL Link: kzbin.info/www/bejne/pHPFloCNrrGKrq8
@rutujapowar4616
@rutujapowar4616 2 жыл бұрын
If we have username is hr, password is hr and SID is ORCL then how to connect and their is need to download oracle 21c express for Oracle SQL developer and my oracle sql developer shows load tns file no tns entries found in user plz help me
@REGexSoftware
@REGexSoftware 2 жыл бұрын
Hey Rutuja, First of all thanks for watching this video, this video is made in reference to unlock the HR user in Oracle 11g express edition. The steps are little different for oracle 21c express edition, although remember one thing sql developer can be used with any version of Oracle database. And for sure HR user steps are different in other version of databases.
@rutujapowar4616
@rutujapowar4616 2 жыл бұрын
@@REGexSoftware plz make video on this for Oracle 21 express edition
@rutujapowar4616
@rutujapowar4616 2 жыл бұрын
@@REGexSoftware I did what you shown in video but it isn't connected plz tell me how i delete this hr user which i try to connect and how i connect it in oracle 21 express edition
@sabasharikmaslat9235
@sabasharikmaslat9235 10 ай бұрын
Its very imp plz reply
@akshaythakur2103
@akshaythakur2103 Жыл бұрын
Please show how you set the user name. When creating account for oracle it takes user name as EMAIL address only. All the videos on KZbin just showing how to make connections but not showing how to get those credentials which we have to use for making the connection.
@akshaythakur2103
@akshaythakur2103 Жыл бұрын
Installation is not the most difficult thing. Sir please help me with making the connection
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey Akshay, first of all make the connection with sys user as it behave like admin and put the password that you have provided at time of installation. Apart from this you can follow along with the video to make hr user connection with the password as hr as mentioned in the vidoe section Link : kzbin.info/www/bejne/pHPFloCNrrGKrq8
@nomulanikhila4722
@nomulanikhila4722 10 ай бұрын
How to create another user account and password
@muzamilzaman7463
@muzamilzaman7463 2 жыл бұрын
Do we need to install Oracle 11g first ???
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey Muzamil, Yes you need to have Oracle installed otherwise how you will make a connection with the same.
@bommanagayathri82
@bommanagayathri82 Жыл бұрын
Can you advise how to connect new db connection
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey you can follow the steps as mentioned in this video: kzbin.info/www/bejne/pHPFloCNrrGKrq8
@parasunirmala2398
@parasunirmala2398 Жыл бұрын
Sir,I did same as you say but after opening SQL developer it shows warning that could not install some modules
@REGexSoftware
@REGexSoftware Жыл бұрын
That might be the issue because of Java Jdk or try running it as an administrator
@parasunirmala2398
@parasunirmala2398 Жыл бұрын
@@REGexSoftware I did it it shows the same warning
@REGexSoftware
@REGexSoftware Жыл бұрын
@@parasunirmala2398 Have you checked the Java installation & also whether the path is set or not ? Try to run the database through administrator user
@parasunirmala2398
@parasunirmala2398 Жыл бұрын
@@REGexSoftware database connected
@lightyagami3797
@lightyagami3797 Жыл бұрын
i did the steps but there is no TNS file . what to do?
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey Yagami, Have you install oracle database before installing sql developer? If yes, then check the location where you have done the installation of database, sql developer only provides you the connection with your database that you have installed in your local base machine
@lightyagami3797
@lightyagami3797 Жыл бұрын
@@REGexSoftware hi, can you tell me what all things to download for sql developer to work. or if possible can your share the link with me as it is very confusing for me. That would be a great help if you do!!
@dinesh-tv4ip
@dinesh-tv4ip 2 жыл бұрын
Insufficient privileges error bro
@REGexSoftware
@REGexSoftware 2 жыл бұрын
Hey Dinesh, Try to execute the commands only with sys user. And while making the hr user connection make hr as username & password
@poojamore8815
@poojamore8815 Жыл бұрын
I don't know when we set the password???
@REGexSoftware
@REGexSoftware Жыл бұрын
when we used alter user hr identified by hr; using the same command we did the same Hope now you understand
@lailazaher9750
@lailazaher9750 2 жыл бұрын
Sir please What about the password in 3.11
@REGexSoftware
@REGexSoftware 2 жыл бұрын
Hey Laila, Password is the same as you set for the user while you unlock them
@MrBvnagesh
@MrBvnagesh Жыл бұрын
Dear brother,I have created database same as you shown in the video,but once give a command like select * from employees or customers,I am getting error ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" *Cause: *Action: Error at Line: 1 Column: 15 please help me on the same
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey Nagesh, You can follow along this video to unlock HR user as this HR user contain the dummy schema for the learning of Oracle SQL Link: kzbin.info/www/bejne/pHPFloCNrrGKrq8
@MrBvnagesh
@MrBvnagesh Жыл бұрын
@@REGexSoftware Thanks for reply
@telugutechbuzz6780
@telugutechbuzz6780 Жыл бұрын
user name and password Not coreect for connection of db
@REGexSoftware
@REGexSoftware Жыл бұрын
Hey, kindly try to unlock the user as per the given video in this link : kzbin.info/www/bejne/pHPFloCNrrGKrq8
@shaikmasthan3585
@shaikmasthan3585 2 жыл бұрын
What about password brother
@REGexSoftware
@REGexSoftware 2 жыл бұрын
If you have unlocked the HR user using the same approach as mentioned in the video then the password will be the hr only. I hope it works for you now!
@smitapawal9772
@smitapawal9772 2 жыл бұрын
pwd plz
@REGexSoftware
@REGexSoftware 2 жыл бұрын
If you have followed the same steps hr is the password for the hr user
@smitapawal9772
@smitapawal9772 2 жыл бұрын
@@REGexSoftware status failure the network adaptor could not establish the connection.
@venkateswarlumuttineni295
@venkateswarlumuttineni295 Жыл бұрын
Same issue please help me
@Venunaidu45
@Venunaidu45 Жыл бұрын
Password
@mychannel2450
@mychannel2450 Жыл бұрын
Ok
Heartwarming moment as priest rescues ceremony with kindness #shorts
00:33
Fabiosa Best Lifehacks
Рет қаралды 37 МЛН
Русалка
01:00
История одного вокалиста
Рет қаралды 7 МЛН
HOW DID HE WIN? 😱
00:33
Topper Guild
Рет қаралды 49 МЛН
Alex hid in the closet #shorts
00:14
Mihdens
Рет қаралды 7 МЛН
Installing MySQL and Creating Databases | MySQL for Beginners
12:04
Alex The Analyst
Рет қаралды 320 М.
How to install sql developer on Windows 10 Pro 64 bit
7:47
Safaa Al-Hayali
Рет қаралды 412 М.
How I use SQL as a Data Analyst
15:30
Luke Barousse
Рет қаралды 812 М.
you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)
24:25
NetworkChuck
Рет қаралды 1,5 МЛН
How connect Oracle SQL Developer to a local Oracle database
6:25
Oracle SQL Developer: Query Builder Demo
8:13
Jeff Smith
Рет қаралды 167 М.
Копия iPhone с WildBerries
1:00
Wylsacom
Рет қаралды 367 М.
Look, this is the 97th generation of the phone?
0:13
Edcers
Рет қаралды 3,8 МЛН
iPhone 15 Pro в реальной жизни
24:07
HUDAKOV
Рет қаралды 408 М.