How to retrieve data with single quotes from Oracle database fields

Owned by Amulya Akula (Inactive) (Deactivated)
Last updated: Feb 17, 2020 by Smita Nair

This article explains how to retrieve data that are in single quotes from the Oracle database using the Run Self-Service Reports and the SQL for Confluence apps.

Instructions

First, you must ensure that the table you want data from has data with single quotes. You can perform the following steps to check the data of a specific table:

  1. Log in to your Confluence instance.
  2. Navigate to the required page and click.
  3. Insert SQL Query macro, click Edit, and enter a query as follows:

  4. Click Save settings and Publish the page. In this example, details from the customer table is displayed on the page as: