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

    Manage APEX database in SQL developer

    2658405

      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.

      Thanks

      Ari

        • 1. Re: Manage APEX database in SQL developer
          rdarlin

          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.

          Rich

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

            '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.