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

*****************************************************************************************
* 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:

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:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

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