Oracle DBA Tutorial 10 - How to connect Oracle database with SQL Developer

Published: 05 June 2022
on channel: Chirags Tutorial

117

[email protected] Chirag's Oracle DBA Tutorial https://www.chirags.in
*****************************************************************************************
* How to connect Oracle database with SQL Developer *
*****************************************************************************************

A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer's main objective is to help the end user save time and maximize the return on investment in the Oracle Database technology stack.

Download SQL Developer:
https://www.oracle.com/tools/download...

Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba) from command line.
2. run the below commands.

Flow the tutorial 3 or 4 for creating user, tablespace and creating datafile.

SQL⇒ select username from dba_users;

lets take the user chirag.
##Open SQL Developer.. and connect the database.

Get the SID details from below command.
SQL⇒ Select name from v$database;

ORCL

using user details create the connection in SQL Developer.

Now run the below command for getting session count.

SQL⇒ select count(*) from v$session;

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/orac...

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be avilable in our website.
Link will be available in description.

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags

Watch video Oracle DBA Tutorial 10 - How to connect Oracle database with SQL Developer online without registration, duration hours minute second in high quality. This video was added by user Chirags Tutorial 05 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 117 once and liked it 2 people.

5,521