Oracle Apps Modules

Creating Connection to Oracle 12c from SQL Developer

Creating your First connection to Oracle 12c from SQL Developer

  • Oracle SQL Developer enables developers and DBAs to browse, create, and update data in a database.
  • You must have at least one database connection to use Oracle SQL Developer.

Steps to create Database connection in Oracle SQLDeveloper

Step 1: Right click on connection and select new connection 

SQL Developer

Step 2: Define Connection name 
give username and password which you have given during installation
and define Connection type as TNS and select Role SYSDBA
Select SID as ORCL and Click on Test to Test the Connection

SQL Developer

Step 3: If it is showing success message then click on connect

c3

Step 4: Now Our connection successfully created
You can write and run query.

SQL Developer

Step 5: Query to get all table name of database schema

SQL Developer

A quick guide to MySQL

 

 

Introduction to PL/SQL tutorial

Leave a Reply