Bookshelf Home | Contents | Index | Search | PDF

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 ("").

Bookshelf Home | Contents | Index | Search | PDF