Oracle Database Online Documentation
10g Release 2 (10.2)
You can develop applications using many operating systems, languages, and tools. Different parts of the application can run inside the database, on an application server, or on a client machine.
The Java programming language is used for database code that runs inside the database, on a middle tier, or on a client system. Many database components have Java APIs that are documented in the Javadoc format.
You can store XML content in the database, and write applications to process it and use it as a data interchange format:
You can store data from different character sets and code pages, and manipulate and present that data as appropriate for each locale:
Oracle interMedia lets you write applications to manipulate images, audio, and video within the database:
SQL and PL/SQL
SQL is the underlying language for all database programming. PL/SQL is tightly integrated with SQL, usually for code running inside the database such as triggers, stored procedures and functions, and PL/SQL packages. SQL*Plus is the command-line tool for running SQL and compiling PL/SQL.
Oracle Call Interface
The Oracle Call Interface is for low-level, efficient coding in C or C++:
Application Developer Guides
These books cover specific aspects of developing with Oracle:
The precompilers are used for traditional client-server applications in various languages: