2 Replies Latest reply on Jan 20, 2017 12:48 AM by thatJeffSmith-Oracle

    Manage APEX database in SQL developer


      HI ,

      I have signed up for the apex  and created application and have some tables that I would like to manage in sql developer.

      for the same I am trying to find the required details for creating the db connection in sql dev.


      could anyone assist me with this please.



        • 1. Re: Manage APEX database in SQL developer

          Here is an example... this works for me when connecting to an Oracle 11Gex instance using the defaults from the database install...

          Make up your own 'Connection Name'...  Enter the DB Username and password for the user you want to connect with...  Hostname would be the servername or IP address... Port 1521 is the default for oracle traffic... the default SID for Oracle Express is XE... put in whatever the SID is for your DB.


          If your setup is more than 'basic' or you don't know this detail, you may need to talk to the DBA who installed or knows the DB in order to get connection inforation.


          1 person found this helpful
          • 2. Re: Manage APEX database in SQL developer

            'signed up for the APEX' - do you mean at apex.oracle.com ?


            If so, you can't connect to that database outside of your APEX account. They do have a schema management bit that allows you to create tables, etc.