Oracle Database XE is a fully free edition of the Oracle Database.

Oracle Database XE supports the following development environments:

• Java: Develop and deploy modern database-bound Java Web applications (Servlets), modules (Microservices) or standalone Java frameworks using the Oracle JDBC Driver, the Universal Connection Pool (UCP), and the Database-embedded JVM (for in-place, server-side processing).

  Visit https://www.oracle.com/database/technologies/appdev/jdbc.html for more information.

• C and C++ : Developers can use Oracle Call Interface (OCI) and Oracle C++ Call Interface (OCCI) to create high performance programs accessing Oracle Database XE. ODBC and the ODPI-C wrapper over OCI are also usable.

  Visit https://www.oracle.com/technetwork/database/features/oci/index-090945.html for more information.

• .NET: Visual Studio and .NET developers can use Oracle Data Provider for .NET (ODP.NET) and Oracle Developer Tools for Visual Studio (ODT) for full development life cycle support.

  Visit https://www.oracle.com/database/technologies/appdev/dotnet.html for more information

  For a walkthrough on creating a .NET application with Oracle Database XE:

  visit https://www.oracle.com/tools/technologies/quickstart-dotnet-for-oracle-database.html.

• Oracle SQL Developer: Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient way to perform basic tasks. You can connect to any target Oracle Database XE schema using standard Oracle database authentication. Once connected, you can perform operations on objects in the database.

  Download and install Oracle SQL Developer from:

  https://www.oracle.com/database/sqldeveloper/

• Oracle SQL Developer Web: Included with Oracle REST Data Services, Oracle SQL Developer Web is the web-based version of Oracle SQL Developer that enables you to execute queries and scripts, create database objects, build data models, and monitor database activity.

• Oracle Developer Tools for VS Code: This free Visual Studio Code extension enables editing and execution of SQL and PL/SQL for Oracle Database and Oracle Autonomous Database.

  Download and install Oracle Developer Tools for VS Code from the Visual Studio Code Marketplace:

  https://marketplace.visualstudio.com/items?itemName=Oracle.oracledevtools.

• Oracle Application Express: Oracle Application Express (APEX) is a rapid web application development tool for the Oracle database.

  Download and install Application Express from:

  http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html

• Oracle REST Data Services (ORDS): ORDS makes it easy to develop modern REST interfaces for relational data in the Oracle Database and the Oracle Database 21c JSON Document Store.

  Download and install ORDS from: 

  https://www.oracle.com/database/technologies/appdev/rest.html

• SODA (Simple Oracle Document Access) APIs that let you develop NoSQL-style applications against collections of JSON documents. Native language SODA drivers are available for common languages.

  Visit https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/ for more information.

You can use scripting languages such as:

• PHP

  Access Oracle Database with the PHP OCI8 extension or the PDO_OCI Driver. PHP OCI8 and PDO_OCI are part of the PHP open source project.

  Visit http://php.net/oci8 for more information on PHP OCI8 and http://php.net/pdo_oci for more information on PDO_OCI.

• Python

  The cx_Oracle Python extension module enables access to Oracle Database.

  Visit https://oracle.github.io/python-cx_Oracle/ for more information about cx_Oracle Python extension module.

• Node.js

  The node-oracledb add-on for Node.js powers high performance Oracle Database applications.

  Visit https://oracle.github.io/node-oracledb/ for more information about node-oracledb.

• ROracle

  ROracle is an open source R package supporting a DBI-compliant Oracle driver based on the high performance OCI library.

  Visit http://cran.r-project.org/web/packages/ROracle/index.html for more information about ROracle.

• Ruby

  Build Ruby and Ruby on Rails applications using the ruby-oci8 driver or JRuby with the Oracle Enhanced Adapter for ActiveRecord.

  Visit:

  • http://www.rubydoc.info/gems/ruby-oci8/ for information about the ruby-oci8.

  • http://jruby.org/ for information about JRuby.

  • https://github.com/rsim/oracle-enhanced for information about Oracle Enhanced Adapter.

   

• Others

  Accessing Oracle Database XE from other languages including Go is possible using community drivers based on OCI or ODPI-C.

  Download Open Source drivers from:

  http://www.oracle.com/technetwork/database/database-technologies/scripting-languages/index.html

For more information on Oracle Database XE, see the following:

• Oracle Database XE home page on the Oracle Technology Network:

  Visit https://www.oracle.com/database/technologies/appdev/xe.html.

• Oracle Database XE Discussion Forum:

  You can search the Oracle Database XE Discussion Forum for answers to problems already discussed and post new questions to the community for answers.

  Visit https://community.oracle.com/tech/developers/categories/oracle_database_express_edition_xe.