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 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
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.
You can download query results to a CSV file.
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.
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.
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.
Click on Create App button from within the Script Editor to parse your SQL script and create an App in just few clicks.
Oracle APEX provides many useful utilities to manage data and maintain your database objects.
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.
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.
Rapidly design and prototype data models using a markdown-like shorthand syntax that expands to standards-based Oracle SQL.
Use Sample datasets to build sample applications.
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.
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.
Restore database objects that have been dropped.
Access numerous reports to help you better manage the database objects in your schema.
For those with DBA access, you can review the underlying database details.
For those with DBA access, you can run database activity reports.
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.Oracle REST Data Services
Modules provide the base path for the URI definition. It is a container that is used to group related RESTful Services together.
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 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.