SQL Developer

SQL Developer is a free graphical tool that Oracle provides for database development. This tool supports several platforms, so it is useful for managing environments with multiple platforms, such as SQL Server and Oracle. With SQL Developer, you have a tool to work with the database objects, develop code for the database, and even do some unit testing and data modeling in one place.

SQL Server DBAs will find that SQL Developer has a more familiar look and feel than the other Oracle tools. Instead of drilling down to new windows for information, as in OEM, you can right-click on objects to view properties and perform tasks, as shown in the example in Figure 5-5.

FIGURE 5-5. SQL Developer

The first step in using SQL Developer is ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.