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/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
