How to connect to a database with Oracle SQL Developer

sql database oracle connection
11,436

Oracle has excellent documentation on creating connections in SQL Developer both within the application help, but also on their technology network website: OTN Getting Started with SQL Developer. This viewlet found on that page nicely walks you through the process Connect to Database.

You will need a username and password, the hostname and port, and a SID.

Share:
11,436
anton2g
Author by

anton2g

Updated on June 04, 2022

Comments

  • anton2g
    anton2g almost 2 years

    I need to connect to a database with Oracle SQL-Developer.

    What I know from the DB is the Instance name and a Database Role.

    How do I connect to the database or what more information do I need?

    • Branko Dimitrijevic
      Branko Dimitrijevic over 12 years
      Do you have username and password?
  • kkica
    kkica over 4 years
    where does one find those username, pasword, hostname, port and sid?

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?
How to troubleshoot crashes detected by Google Play Store for Flutter app
Cupertino DateTime picker interfering with scroll behaviour
Why does awk -F work for most letters, but not for the letter "t"?
Flutter change focus color and icon color but not works
How to print and connect to printer using flutter desktop via usb?
Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0
Flutter Dart - get localized country name from country code
navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage
Android Sdk manager not found- Flutter doctor error
Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)
How to change the color of ElevatedButton when entering text in TextField

Related

Oracle database search all tables for string, return row data
Comparing list of values against table
rownum issue in oracle query
Error report: SQL Error: A foreign key value has no matching primary key value. Completely baffled
SQL Error: ORA-00906: missing left parenthesis 00906. 00000 - "missing left parenthesis"
User-Role-Permission based database design
Oracle - Modify an existing table to auto-increment a column
What is difference between JOINS and SUBQUERIES?Can anything we can do with joins can be done with subqueries also or vice-versa?
How should I import/run a .pkb file for Oracle Database?
Trigger to check for duplicates