Oracle SQL Tutorial

This tutorial prepares the Oracle Database 10g Express Edition Developer to perform common development and administrative tasks of Oracle Database 10g Express Edition.

Learning Objectives
After taking this tutorial, you should be able to:

Install Oracle Database 10g Express Edition
Access the Oracle Database Home Page
Manage Database Objects
Access and Manipulate Data
Create an Application using HTML DB 2.1
Add PL/SQL Functionality to an Application
Administer and Monitor the Database
Create an Application using Visual Studio .NET
Create an Application using PHP

PL/SQL is a database-oriented programming language that extends Oracle SQL with procedural capabilities. We will review in this lab the fundamental features of the language and learn how to integrate it with SQL to help solve database problems

This document presents Oracle's data dictionary, also called the system catalogue. The data dictionary is the repository of all the meta-data relevant to the objects stored in the database-and also of information concerning the DBMS itself.

Oracle SQL Built-In Functions
Character/String Functions
Function Description Example

Before you set up EA for use with Oracle, we recommend you run the Tools | Data Management | Data Integrity tool on the base project you wish to upsize to Oracle. This will ensure data is 'clean' before uploading.