If you do not want to see all the Table Columns, or if you have the required privileges and want to see blinded data, then click the Customize button on the Browse Data screen.
You can customize the display through the following options:
Columns. When you click the Customize button for the first time, you can see the Table's Column names in an area titled Included Columns. Another area titled Available Columns contains no Column names. This is because by default, all Columns are selected for viewing.
You can remove one or more Columns from view and also reorder them. After reordering, the Column on the top in the Included Columns area in the Customize Data Browse screen appears on the left in the Browse Data screen, and so on. Do the following:
1. To remove Columns from view. Select the Column or Columns you want to remove from view and move them into the Available Columns area of the shuttle.
Note: In a Work Area you can see whether or not a Table instance contains data. If the value in the Has Data column for the Table instance is Yes, it contains data; if it is No, it does not contain data. You can also see the latest and the installed Table instance version numbers in the Work Area's Properties screen.
Viewing Data
You can use Shift+Click or Ctrl+Click to select multiple Columns. You can double-click to move them or use the arrows.
2. To reorder columns. Use the Up and Down arrows to reorder the Columns in the Included Columns area.
3. Click Apply.
You can now see the Columns you selected, in the order you selected.
Where Clause. You can use the Filter Table instance where feature to restrict the data you see. To set up a Where filter,
1. Select either of the conditions to associate with a Table instance Column. ■ Show results when ALL results are met
■ Show results when ANY results are met
2. Select a Column from the drop-down list in the Column field. All available Columns are listed according to their position.
3. Select a filter condition from the drop-down list. The available conditions depend on the type of data in the particular Column.
4. Enter a value to filter by and select Apply. If the data type is VARCHAR 2, you can select the Match Case checkbox to filter values by case.
You can add different filter conditions to the same Column or view a combination of different Columns and conditions.
To include more Columns, select a Column from the drop-down list in the Add Another section and select Add. You can then apply filter conditions to the second Column. Similarly, use the Remove button to remove a Column and its filter conditions.
For example, for a Demography table with Columns Age, Sex and Race, you can set up the following Where filters:
■ To retrieve data about patients who are over 50 years old, select: Column—Age, Condition—Greater than, Value—50
■ To see data about female patients who are older than 50 years, select:
Column—Age, Condition—Greater than, Value—50. Add another Column and select:
Column—Sex, Condition—Is, Value—Female
■ To see records for patients of all races except white, select: Column—Race, Condition—Is not, Value—White
Order By Clause. You can organize the data retrieved in any order using the Order Table Instance by feature. You can specify an ascending or descending order for the Column's values. By default, the system displays records by sorting the values from the Column with an order number of 1 in ascending alphabetical or numerical order, depending on the Column's data type.
To order a Table instance:
1. Select a Column from the drop-down list in the Column field. Columns are listed according to their position in ascending order. Once selected, a Column does not appear in the list.
Viewing Data
2. Select either Ascending or Descending from the drop-down condition list. Data is sorted in ascending order by default.
3. Select Apply.
You can add more Columns to order and view by using the choice list in the Add Another section, and selecting the Add button.
Use the Remove button to remove a column from the Table instance display. For example, for a Demography table with Columns Age, Race, and Sex: ■ To sort data by Age, select:
Column—Age
■ To sort data by Race, select: Column—Race
■ To sort data in descending order of Age, and then ascending order of Sex, select: Column—Age, Condition—Descending. Add another column and select: Column —Sex
Blind Break The options you see in the Blind Break drop-down list depend on the state of the Table instance and on your privileges:
■ Currently Blinded Table Instance. If the table contains blinded data, you may see the following options:
– Dummy. The system displays dummy data, not the real, sensitive data. This is the default behavior.
– Real (Blind Break). The system breaks the blind to show you the real, sensitive data. This option is available only if you have the necessary blinding-related privileges. The Table instance remains blinded.
■ Unblinded Table Instance. If the table has been unblinded, you may see the following options:
– Real (Unblinded). The system displays the real, sensitive data that has been unblinded (made available to everyone with Read Unblind privileges). This option is available only if you have the necessary privileges. This is the default behavior for people with those privileges.
– Dummy. The system displays dummy data, not the real, sensitive data. This is the default behavior for people who do not have Read Unblind privileges. ■ Table Instance without Blinding. If the table does not support blinding (its
Blinding Flag is set to No), the system always displays real data; the Table Tip: You can find more information on SQL in these books:
Oracle® DatabaseSQL Language Reference at
http://download.oracle.com/docs/cd/E11882_ 01/server.112/e17118.pdf
Oracle® Database PL/SQL Language Reference at
http://download.oracle.com/docs/cd/E11882_ 01/appdev.112/e17126.pdf
Oracle® Database Reference at
http://download.oracle.com/docs/cd/E11882_ 01/server.112/e17110.pdf
Viewing Jobs
instance does not contain dummy data. The only option in the Blind Break drop-down list is Not Applicable.