oracle developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.        

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?and 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

The preceding tasks, and many others, are described in?Oracle Database 2 Day Developer's Guide?and?Oracle Database Advanced Application Developer's Guide.

See Also:

"Introduction to Server-Side Programming"
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 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

SQL Developer is available in the default Oracle Database installation and by free download..