2 Introduction

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

Development Environments

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 http://oracle.com/jdbc 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

• 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:

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

• 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 18c 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

Scripting Languages

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.

Oracle Call Interface (OCI) Demonstration Programs

A set of OCI demonstration programs and their corresponding project files are available in the $ORACLE_HOME/demo subdirectory after an Oracle Database Express Edition (XE) installation.

You can run these OCI demonstration programs to familiarize yourself with the steps involved in developing OCI applications. The Oracle Database Express Edition (XE) does not support generating the client shared library. The build option in demo_rdbms.mk is not valid for XE. You can compile and link application and demo programs with the provided header files. Because the object (.o's) and archive (.a's) libraries are not available in the installed location, you cannot use genclntsh and genclntst.

Examples

You can download and install Oracle Database Examples in an existing Oracle home to view the product demonstrations.

See Examples Installation Guide for more information about products available on the Oracle examples media

Examples are also available from https://github.com/oracle/oracle-db-examples

Learning More About Oracle Database XE

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 that forum to see if the problem has already been discussed; and if you do not find the answer, you can create a new thread and provide the details.

  Visit https://community.oracle.com/community/technology_network_community/database/developer-tools/oracle_database_express_edition_xe/overview