Скачать или смотреть 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:
   / @chiragtutorial  
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

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

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags
#ChiragTutorial
#ChiragsTutorial
#Chirags
#Chirag
#ChittRanjanMahto
#ChiragMahto
#OracleDatabase
#SQLDeveloper
#OracleSQLDeveloper
#OracleConnection
#DatabaseConnection
#OracleTutorial
#SQLDeveloperTutorial
#OracleDatabaseConnection
#OracleDatabaseTutorial
#OracleSQL
#OraclePLSQL
#OracleDB
#Oracle11g
#Oracle12c
#Oracle19c
#Oracle21c
#OracleXE
#OracleExpressEdition
#OracleClient
#OracleServer
#OracleInstallation
#OracleSetup
#OracleConfiguration
#OracleAdmin
#OracleAdministration
#OracleDBA
#DatabaseAdministration
#DatabaseAdmin
#SQL
#PLSQL
#SQLTutorial
#PLSQLTutorial
#DatabaseTutorial
#SQLQueries
#SQLCommands
#SQLScripts
#SQLProgramming
#DatabaseProgramming
#DatabaseManagement
#DBMS
#RDBMS
#RelationalDatabase
#DataModeling
#DataManagement
#DataAdministration
#DataAnalysis
#DataAnalytics
#DataScience
#BigData
#DataEngineer
#DataEngineering
#ETL
#DataWarehouse
#BusinessIntelligence
#BI
#Informatica
#DataIntegration
#DataMigration
#DataReplication
#DataBackup
#DataRecovery
#DisasterRecovery
#HighAvailability
#PerformanceTuning
#QueryOptimization
#Indexing
#Partitioning
#Clustering
#Sharding
#Replication
#Failover
#LoadBalancing
#Scalability
#Security
#DataSecurity
#Encryption
#Authentication
#Authorization
#Auditing
#Compliance
#GDPR
#HIPAA
#SOX
#IT
#InformationTechnology
#TechTutorial
#ProgrammingTutorial
#CodingTutorial
#SoftwareDevelopment
#SoftwareEngineering
#ComputerScience
#ITTraining