What’s Oracle?

Oracle is a product from Oracle corporation, that provides a relational database management system. Oracle’s database simply known as Oracle is a multi-model relational database management system, mainly designed for enterprise grid-computing and data warehousing. It is one of the first choices for enterprises for cost-effective solutions for their applications and data management. It supports SQL as a query language to interact with the database.

Now let’s discuss how to use Oracle in the FDU environment.

Accessing Oracle

FDU provides Oracle access to students and faculty on the Opus server. The Oracle environment is provided to support coursework and skill development.

You will need to request Opus access by selecting “Opus (Linux) Request” on the FDU Forms site:

You will need to use SSH to connect to the Opus server:

The Oracle Database is accessed using the SQL Plus utility, which has a command-line interface. To start using SQL Plus simply type “sqlplus /” on the Opus command line.

Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:

SQL> select 'Hello world' as example from dual;

EXAMPLE
--------------------------------
Hello world
Last Modified: April 19, 2021 icon icon Copy Link