Oracle offers the SQL Developer as a free tool designed to help programmers work with Oracle databases. SQL Developer provides graphical representations that show programmers the results of queries. It also aids in the debugging process of PL/SQL programming. SQL Developer runs on Windows, Mac and Linux. It also can connect to other databases, such as IBM's DB2 database system, to copy tables and data, as well as helping programmers to develop SQL code for those other database systems.
- Skill level:
Open SQL Developer. Click "File" in the top toolbar menu and click "Open connection."
Click the "DB2" tab in the Connection dialogue box. Enter the name of the DB2 database in the first box. Enter the host and port information, as well as the driver type. You can choose between entering "IBM DB2 Application Driver" or "IBM DB2 Network Driver" for the driver type. Enter the user name and password to access the DB2 database.
Click "Info" at the bottom of the Connection dialogue box to test the connection with the settings you entered. Click "OK" to create the connection to the DB2 database.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for