Oracle® Business Intelligence Data Warehouse Administration Console Guide > Overview of the DAC Interface > Using the DAC Query Functionality >
DAC Query Examples
The following examples show different ways you can query on the Name column of the Tasks tab. Extract* lists all tasks whose name starts with Extract.
*Extract* lists all tasks whose name contains the word Extract .
!Extract* lists all tasks whose name does not start with the word Extract.
!null lists all tasks whose name is not null.
Extract* or Aggregate* lists all tasks whose name starts with Extract or Aggregate .
Load* and *Aggregate* lists all tasks whose name starts with Load and also contains the word Aggregate.
"Extract for Wave Dimension" or "Load into Wave Dimension" lists tasks whose name is either Extract for Wave Dimension or Load into Wave Dimension .
NOTE: When using spaces within strings, you need to surround the string with quotes ("").
|