1. Using Oracle Database Exadata Express Cloud Service
  2. Develop on the Database
  3. Manage Data with Oracle Application Express SQL Workshop

Manage Data with Oracle Application Express SQL Workshop

The Oracle Application Express SQL Workshop provides you with tools to manage data in your Oracle Database Exadata Express Cloud Service.

Topics:

Use Oracle Application Express SQL Workshop to Develop the Database

The Oracle Application Express SQL Workshop Object Browser enables developers to browse, create, and edit objects in a database. Oracle Application Express has many views defined to help you work with the underlying table structures. The views combine multiple base tables and use meaningful column names to minimize complexity and to be more intuitive to use.

See Oracle Application Express API Reference for details of the views defined.

To manage data using Object Browser:

  1. Access Oracle Application Express Application Builder from Oracle Database Exadata Express Cloud Service service console. See Access Oracle Application Express.

    The Oracle Application Express components displays.

  2. Click Go to SQL Workshop.

    The Oracle Application Express SQL Workshop home page displays.

  3. Click Object Browser.

  4. Browse, create, edit and delete database objects.

    To learn more, see Managing Database Objects with Object Browser in Oracle Application Express SQL Workshop Guide .

Use Oracle Application Express SQL Workshop Data Upload Utility

The Data Upload utility enables you to upload data from a text file, an XML document or a spreadsheet. The utility is accessed from the Oracle Application Express SQL Workshop.

Note:

Files uploaded with Oracle Application Express SQL Workshop must not exceed 100MB. For files larger than 100MB, please use Oracle SQL Developer.

To upload data using the Data Upload utility:

  1. Access Oracle Application Express Application Builder from Oracle Database Exadata Express Cloud Service service console. See Access Oracle Application Express.

    The Oracle Application Express components displays.

  2. Click Go to SQL Workshop.

    The Oracle Application Express SQL Workshop home page displays.

  3. Click Utilities.

  4. Click Data Workshop.

  5. Under the Data Load category, click one of the following types of data:
  6. Follow on-screen instructions.

To learn more about uploading data with the Data Upload utility, see Loading Data in Oracle Application Express SQL Workshop Guide .

Use Oracle Application Express Data Upload with Spreadsheet

The Oracle Application Express Data Upload utility enables you to upload data from a text file, an XML document or a spreadsheet. The utility is accessed from the Oracle Application Express SQL Workshop.

  1. Access Oracle Application Express Application Builder from Oracle Database Exadata Express Cloud Service service console. See Access Oracle Application Express.

    The Oracle Application Express components displays.

  2. Click Go to SQL Workshop.

    The Oracle Application Express SQL Workshop home page displays.

  3. Click Utilities.

  4. Click Data Workshop.

  5. Under Data Load category, click Spreadsheet Data.

    The Load Data - Target and Method wizard appears.


    Description of load_data.png follows
    Description of the illustration load_data.png

  6. Select a suitable option for Load To: and Upload file (comma separated or tab delimited) for Load From:. .

    Note:

    You can load the data from a csv file, or even copy and paste the csv formatted data directly in the copy-paste area in this wizard. To copy the data directly into the wizard, select Copy and Paste for Load From:
  7. click Next >.

  8. Choose the file for data upload, select the values for other fields on the wizard as required, and click Next >.

    Note:

    The file to be uploaded must be text-based. To upload a .XLS file, first save it as CSV.
  9. Follow on-screen instructions.

To learn more about uploading data with the Data Upload utility, see Using Data Workshop in Oracle Application Express SQL Workshop Guide .

Use Oracle Application Express SQL Workshop to Export Data

The Data Unload utility provided by Oracle Application Express SQL Workshop, enables you to export data from your Oracle Database Exadata Express Cloud Service into a text file, an XML document or a spreadsheet.

To export data using the Data Unload utility:

  1. Access Oracle Application Express Application Builder from Oracle Database Exadata Express Cloud Service service console. See Access Oracle Application Express.

    The Oracle Application Express components displays.

  2. Click Go to SQL Workshop.

    The Oracle Application Express SQL Workshop home page displays.

  3. Click Utilities.

  4. Click Data Workshop.

  5. Under the Data Unload category, click one of the following options depending on the required format for the exported data:

    • to Text

    • to XML

  6. Follow on-screen instructions.

To learn more about exporting data with the Data Unload utility, see Unloading Data in Oracle Application Express SQL Workshop Guide .

Upload Data with SQL Scripts

The SQL Scripts functionality allows you to create, upload, and run SQL scripts that insert data into the database. You could use an SQL script to load data into your Oracle Database Exadata Express Cloud Service.

Note:

Files uploaded with Oracle Application Express SQL Workshop must not exceed 100MB. For files larger than 100MB, please use Oracle SQL Developer.

These operations are accessed from the Oracle Application Express SQL Workshop.

To insert data using SQL Scripts:

  1. Invoke Oracle Application Express components from theOracle Database Exadata Express Cloud Service service console. See Access Oracle Application Express.

    The Oracle Application Express components displays.

  2. Click Go to SQL Workshop.

    The Oracle Application Express SQL Workshop home page displays.

  3. Click SQL Scripts.

  4. Create or upload an SQL script.

    To learn more, see Creating a SQL Script in the Oracle Application Express SQL Workshop Guide .

  5. Click the Run icon for the SQL script you want to execute.

    To learn more about running SQL scripts, see Executing a SQL Script in Oracle Application Express SQL Workshop Guide .

To learn more about using SQL scripts to load data, see Using SQL Scripts in Oracle Application Express SQL Workshop Guide .