Application development for Oracle Database involves a wide range of programming technologies. The 2 Day + books walk through the process of creating a basic application in various programming languages. The supporting documentation covers the languages, programming interfaces, and development tools in detail.
The 2 Day Developer's Guide introduces basic technologies and concepts used in Oracle application development. Each 2 Day + Developer's Guide describes using a different development platform or language to implement the same sample application: a Web-based application for viewing and modifying employee data for an imaginary company named "AnyCo Corp".
Administrator's Reference for Linux and UNIX-Based Operating Systems
SQL and PL/SQL Languages
SQL and PL/SQL are fundamental to all Oracle application development. SQL is the language used to query and modify Oracle databases. PL/SQL is used to create and call triggers, stored procedures and functions, and PL/SQL packages. Other programming technologies depend upon SQL and PL/SQL to interact with the Oracle Database server.
SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer provides all the same capabilities as SQL*Plus, as well as an easy-to-use, powerful drag-and-drop GUI for managing database objects and creating and viewing reports. Oracle also provides extensions for Microsoft's Visual Studio development environment to support developing applications on .NET platforms.
Communications Data Model Operations Guide
Oracle Application Express (APEX) is a rapid Web application development tool for Oracle Database. With only a Web browser, users with limited programming experience can develop scalable, secure, and efficient Web applications. Deployment requires only an Oracle Database running APEX.
The Java programming language is used for database code that runs inside the database, on a middle tier, or on a client system. Reference documentation for database components that have Java APIs is presented in Javadoc format.