Siebel Data Warehouse Installation and Administration Guide > DAC Quick Start > 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 ("").

Siebel Data Warehouse Installation and Administration Guide