Connecting to databases - Oracle

This tutorial shows how to connect to Oracle 10G XE. SQL Developer supports other databases for which you can find the correct syntax for connection Information.

Connecting to the Oracle 10G XE database

It will be helpful if you refresh your Oracle 10G XE knowledge or read the several Oracle 10G XE articles on the DevShed site. This is a good place for you to look at new developments, scripts, UI description, etc. The connection will be made to the Oracle 10G XE with the credentials hr, hr. Click on the "Connections" icon with the bright green plus sign as shown.

This opens up the next window, New/Select Database Connection. This is where you must supply all the information. As you can see it has identified a resident Oracle 10G XE on the machine. Of course you need to configure it further. In addition to Oracle it can connect to MySQL, MS Access, and SQL Server as well.

On the left hand side of this window you will generate the Connection Name and Connection Details once you fill in the appropriate information on the right. Connection name is what you supply; to get connected you need to have a username and password as well. If you want, you can save the password to avoid providing it again and again. At the bottom of the screen you can save the connection, test it and connect to it. There is also access to online help.

Insert the following information:

Connection Name: Test10G (or whatever)
Username: hr
Password: hr (turns to **)
Save Password is selected.
Oracle is default
Connection type: Basic

With this click on the Test button at the bottom. A testing window pops up with a progress bar. Now click on the Connect button, which establishes the connection as shown. When you click on the + node of the Connections for Test10G you can expand the node to see its content as shown. You can further expand the various nodes to see more details.