Date: 13-MAR-2006

This How-To details how use Oracle SQL Developer to connect to your Oracle Database 10g Express Edition (XE).

•  
• Startup Oracle SQL Developer.
• From within the Connections navigator on the left side of the tool, right-click on Connections.
• Select New Database Connection.
• Enter the following information:
  • Connection Name: XE
  • Username: Whatever user you have created or SYS or SYSTEM if you have not created a user yet
  • Password: The password for your user or the default password you entered for SYS and SYSTEM
  • Hostname: 127.0.0.1
    This is only the hostname if your are running SQL Developer on the same machine where your XE is installed.
  • Port: 1521
  • SID: XE
• Click Connect

Your Connections will be expanded for you and a SQL Worksheet will be opened on the right side of the tool against your new connection. You can click the + to the left of your new Connection to view the objects accessible to the connected user or can enter SQL and PL/SQL commands into the SQL Worksheet.

Discuss this how-to in the OTN Oracle SQL Developer Forum.