Getting Started

SQL Workshop

Introduction

SQL Workshop allows you to create, view, and maintain your database objects. All you need is your web browser. Simply sign into your workspace and you're in! This provides incredibly fast and easy access to Oracle Database from the public internet.

Don't have a workspace already? You can get started with a free workspace in moments.

Get Started for Free

Object Browser

Object Browser enables you to use a tree control to view object properties and create new objects.

  • Create New Objects

    Follow simple wizards to create database objects.

  • View and Modify Objects

    Browse and modify tables, views, packages, procedures, and more.

  • Browse Your Data

    Browse and filter data in your tables and views

SQL Commands

You can run any SQL statement or PL/SQL block within SQL Commands. Simply enter in your SQL or PL/SQL block within the command editor and then click Run. You can easily review the results of your command in the display pane at the bottom of the screen.

  • Enter SQL statements

    The SQL command you enter can be used to create, edit, view, run, and delete database objects. Both Database Manipulation Language (DML) and Database Definition Language (DDL) commands can be executed.

  • See statement results

    The display pane will displays results queries and DML statements.

  • Download Data

    You can download query results to a CSV file.

SQL Scripts

A SQL script is a set of SQL commands saved as a file. A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL scripts to create, edit, view, run, and delete database objects.

  • Maintain Scripts

    You can easily create new scripts from scratch, or upload existing files. When you edit a SQL script you are presented with a full page code editor with text highlighting.

  • View Results

    When you run a script then you are presented with a results page which displays each statement run and the feedback for that statement. At any time you can go back into the page and review previous results.

Utilities

Oracle APEX provides many useful utilities to manage data and maintain your database objects.

  • Data Workshop

    Data Workshop enables you to load and unload data to the database. You can load from text, XML, or a spreadsheet into a new table or an existing table. You can also unload data to text or XML.

  • Query Builder

    Build queries graphically by adding tables and views into a panel, and selecting columns to return. You can also create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge.

  • Quick SQL

    Rapidly design and prototype data models using a markdown-like shorthand syntax that expands to standards-based Oracle SQL.

  • Sample Datasets

    Use Sample datasets to build sample applications.

  • Generating DDL

    You can generate data definition language (DDL) statements for all or selected database objects within your schema.

  • User Interface Defaults

    Specify layout properties to consistently generate items / columns across pages and applications.

  • Schema Comparison

    You can run a report that compares database objects in two schemas, displaying differences between them. You can compare all objects in the schemas or limit your report to specific objects.

  • Methods on Tables

    The Methods on Tables utility enables you to create an application programming interface (API), or package, for DML operations on specified tables.

  • Recycle Bin

    Restore database objects that have been dropped.

  • Object Reports

    Access numerous reports to help you better manage the database objects in your schema.

  • About Database

    For those with DBA access, you can review the underlying database details.

  • Database Monitor

    For those with DBA access, you can run database activity reports.

RESTful Services

Create and manage RESTful services using the Oracle REST Data Services (ORDS) based repository. This feature allows you to define RESTful Web service endpoints, or URIs, which allow other applications to extract data from the underlying database objects. Definition are broken down into Modules, Templates and Handlers.

  • Modules

    Modules provide the base path for the URI definition. It is a container that is used to group related RESTful Services together.

  • Templates

    Templates are defined within a module. They are an individual RESTful Service that is able to service requests for some set of Universal Resource Identifiers (URIs ). The URI Pattern of the Resource Template defines the set of URIs.

  • Handlers

    Handlers are defined for a specified template. They provide the logic required to service a specific HTTP operation for the resource template, such as GET, POST, PUT, and DELETE.