I just discovered that NetBeans can allows a user to access databases to view, edit, and execute commands. It looks pretty cool for an IDE. If you prefer to use command line, use sqlplus or command line tool for the database. If you use Windows operating system and Oracle database, TOAD could be another option. If you are using NetBeans and prefer to stay within the IDE, you can use its database features.
To get started, here are my notes on connecting to an existing Oracle database:
1. Click on Runtime tab on the panel on the upper left side.
2. Expand Databases node
3. Right click on Drivers and choose New Driver
4. Click Add
5. Choose class12.zip file from your local file system and click Open
6. Click Ok to accept the default config
7. Right click on database and choose New Connection
8. Seect Oracle driver
9. Change <HOST> with proper host name. Change <PORT> with proper port number. And change <SID> with the proper SID value.
10. Enter a user name and password for the database.
11. Click OK
12. You should see an extra node that shows the connection you established. Expand the code and browse around. Right click on a node and see what tasks you can do.
This little discovery certainly was a pleasant surprise.