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

[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/downloads/sqldev-downloads-2141.html

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:
https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA
?Don't forget to, ?Follow, ?Like, ?Share ?&, Comment

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

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