7.1 Selecting Tables with the Wildcard Selector

Table of Contents Previous Next


7 Common Operations : 7.1 Selecting Tables with the Wildcard Selector

When selecting tables for creating a publication for a single-master replication system (see Section 5.2.3) or a multi-master replication system (see Section 6.2.3), there may be cases where the number of available tables for selection is so large that simply choosing them from a checklist becomes a difficult and time-consuming process.
Pattern matching as performed by the wildcard selector is the process in which the eligible tables for an operation are returned in a filtered list if their schema and table name combination match a character string called a pattern.
Matching a pattern means that the schema and table name combined in a string formatted as schema_name.table_name matches the pattern, character by character, according to the rules designated for the characters appearing in the pattern.
If the schema_name.table_name string matches the pattern, then the schema and table are displayed in the filtered list for that pattern, which is the Available Tables field of the Wildcard Selector dialog box. You can then selectively choose the tables from the filtered list to be added to a local list, which contains the potential, candidate tables for the operation for which you are using the wildcard selector.
With the exception of characters called wildcards, characters appearing in a pattern require that the character in the corresponding position in the schema_name.table_name string must match the pattern character in a case insensitive manner (that is, the letters A or a, match both A and a).
The pattern characters called wildcard characters or simply wildcards are interpreted in a special manner when compared to the corresponding character position of the schema_name.table_name character string.
? – Single-character wildcard specifies that any single character may exist in its position of the pattern. (The SQL LIKE clause uses the underscore character (_) for this purpose.)
% - Multi-character wildcard specifies that any combination of multiple characters, including the absence of any character, may exist in its position of the pattern.
[abc...] – List wildcard specifies that any one of the characters listed within the brackets may exist in its position of the pattern.
[a-d] – Range wildcard specifies that any one character that is greater than or equal to the character preceding the hyphen (-) and less than or equal to the character following the hyphen may exist in its position of the pattern.
[abcd-f...] – List and range combination wildcard specifies that any character that matches any of the list or range wildcard descriptions as described in the previous two bullet points may exist in its position of the pattern.
Any character specified in the pattern other than ?, %, [, ], and the characters enclosed within the square brackets of a list or range wildcard must exist in its position of the pattern. Pattern matching of such characters is case insensitive (for example, a pattern of edb.dept matches a schema and table with the name EDB.Dept).
NOT pattern, !pattern, ! pattern – Exclusive pattern specifies that tables that match the pattern string indicated by pattern are omitted from the filtered list. Tables that do not match pattern are included in the filtered list. The keyword NOT may be in uppercase, lowercase, or mixed case, but must be followed by a single space character preceding pattern. !pattern specifies that pattern immediately follows the exclamation point (!) with no intervening space character. ! pattern specifies that a single space character exists between pattern and the exclamation point (!).
pattern* - Specify the asterisk (*) immediately following the pattern with no intervening space character if you want to include tables in the filtered list that match pattern and have been previously selected (that is, the local list tables) along with tables that have not been selected. In the filtered list, each previously selected, local list table is displayed with a check mark in its check box. Each filtered list table that was not previously selected has no check mark in its check box. By default when the asterisk is omitted, only tables that have not been previously selected are returned in the filtered list. Using the asterisk is useful for removing currently selected tables from the local list.
Calling Dialog Box. This is the dialog box of the operation from which you invoke the Wildcard Selector dialog box. The final set of tables from the wildcard selector is applied to the operation managed by the calling dialog box. Possible calling dialog boxes are the Create Publication dialog box (see Section 5.2.3 for a single-master replication system or Section 6.2.3 for a multi-master replication system), the Add Tables dialog box (see Section 7.6.3.1), and the Remove Tables dialog box (see Section 7.6.3.2).
Table List. This is the list of currently selected tables displayed in the calling dialog box. Each selected table has a check mark in its check box.
Local List. This is a temporary, internal copy of the table list managed by the wildcard selector. The wildcard selector allows you to add tables to the local list and to remove tables from the local list. When you click the Done button of the Wildcard Selector dialog box, the local list becomes the table list. In other words, the local list tables appear as the selected tables of the calling dialog box.
Unselected Tables. These are the tables eligible for, but have not been selected for the operation with which you are using the wildcard selector. When you click the Filter List button, the unselected tables that match the filter pattern are listed in the Available Tables field of the Wildcard Selector dialog box. To list all unselected tables, use the percent sign (%) for the filter pattern.
Selected Tables. These are the tables you have selected for the operation with which you are using the wildcard selector. That is, these are the tables comprising the local list. To display selected tables that match a filter pattern, add the asterisk character (*) immediately after the filter pattern. Each selected table has a check mark in its check box.
Step 1: Prior to opening the Wildcard Selector dialog box, you may start selecting tables from the list of available tables of the calling dialog box by adding a check mark to the check box of each such table.
Step 2: The Available Tables field displays the filtered list matching the pattern used in the Filter Pattern text field.
Step 3: Enter a pattern in the Filter Pattern text field to narrow down your desired table selection. Click the Filter List button to display the tables that match the pattern.
Step 4: Select tables from the Available Tables list that you want to add to the local list by placing a check mark in each such table’s check box. You can also click the Select All check box to select all tables and then individually deselect certain tables by removing its check mark.
Step 5: Click the Apply Selections to Local List button to add the selected tables to the local list.
Note: You can click the Cancel button at any time to terminate the wildcard selector without applying the local list changes to the table list of the calling dialog box.
Step 6: As many times as desired, repeat steps 3 through 5 using the filter patterns needed to add all of your desired tables to the local list.
Step 7: When the local list contains all of your desired, selected tables, click the Done button. The Wildcard Selector dialog box closes, and the local list becomes the list of selected tables displayed by the calling dialog box.
Step 8: You can invoke the wildcard selector again and repeat the process to add tables to, or remove tables from the table list by beginning with Step 1.
Step 9: When the calling dialog box contains the complete list of your desired tables, click the appropriate button of the calling dialog box to complete the operation with the selected tables.

7 Common Operations : 7.1 Selecting Tables with the Wildcard Selector

Table of Contents Previous Next