Oracle Cloud Infrastructure Documentation

Running a Sample Query

Sample queries demonstrate the structured query language syntax and let you change or replace example values to find resources in the tenancy.

  1. In the top navigation bar, click Search for resources, services, documentation, and Marketplace, and then select Advanced resource query.

  2. Click Select Sample Query, and then choose one of the listed sample queries. For an explanation of sample queries, see Sample Queries.

  3. Verify that the query language in the query text box satisfies your needs. Change all example values. Add, delete, or change clauses and their contents, as appropriate, and then click Search.

  4. To filter results more specifically, change the language of the query. For more information about syntax for resource queries, see Search Language Syntax.

    Note

    In advanced query mode, while you can filter and sort results by changing the query language, you can't filter or sort results through the results list displayed in the Console.

The results are eventually consistent, but might not immediately include resources that you created recently. If you don't see the results that you expect, you can change to a different region or edit the query.