Duties of Oracle Developers

An Oracle developer is responsible for creating or maintaining the database components of an application that uses the Oracle technology stack.

Oracle developers either develop new applications or convert existing applications to run in an Oracle Database environment. For this reason, developers work closely with the database administrators, sharing knowledge and information.

Oracle database developers can expect to be involved in the following tasks:

• Implementing the data model required by the application
• Creating schema objects
• Implementing rules for data integrity
• Choosing a programming environment for a new development project
• Writing server-side PL/SQL or Java subprograms and client-side procedural code that use SQL statements
• Creating the application interface with the chosen development tool
• Establishing a Globalization Support environment for developing globalized applications
• Instantiating applications in different databases for development, testing, education, and deployment in a production environment.

Tools for Database Developers

Oracle provides several tools for use in developing database applications. This section describes some commonly used development tools.

SQL Developer

SQL Developer is a convenient way for database developers to edit and develop basic tasks using SQL*Plus.

SQL Developer is a graphical version of SQL*Plus, written in Java, that supports development in SQL and PL/SQL. You can connect to any Oracle database schema using standard database authentication. SQL Developer enables you to:

• Browse, create, edit, and delete schema objects
• Execute SQL statements
• Edit and debug PL/SQL program units
• Manipulate and export data
• Create and display reports