List SQL Reports

Open the navigation menu and select Developer Services. Under Database Tools, select SQL Reports.

The SQL reports list page opens. All SQL reports in the selected compartment are displayed in a table.

To view the SQL Reports in a different compartment, use the Compartment filter to switch compartments.

You must have permissions to work in a compartment to see the resources in it. If you are not sure which compartment to use, contact an administrator. For more information, see Understanding Compartments.

Use filters to limit the SQL Reports in the list. Perform one of the following actions depending on the options that you see:

• From the Search and Filter box above the list table, select one or more filters and specify the values that you want to use to narrow the list. In general, the filters correspond to the columns shown in the list table, although some filters represent attributes that are not shown in the table. The Compartment filter is always displayed next to Applied filters.

• On the left side of the list page, select a value from one of the available filters, such as compartment, state, or tags.

Change the order of the items in the list table by using the sort icons next to the column names.

In the list table, select an SQL Report to view its details. The available tabs are Details, SQL source, Work Requests and Tags.

To perform an action on a selected SQL Report directly from the list table, select any of the following options from the Actions menu in the row for that connection:

To create an SQL Report, select Create SQL report.