1: PROCEDURE ODCIStatsOptionsDump(so ODCIStatsOptions) IS
2: BEGIN
3: if so is null then
4: dbms_output.put_line('ODCIStatsOptions is null');
5: return;
6: end if;
7:
8: dbms_output.put_line('ODCIStatsOptions');
4: dbms_output.put_line('ODCIStatsOptions is null');
5: return;
6: end if;
7:
8: dbms_output.put_line('ODCIStatsOptions');
9: IF (so.Flags = ODCIConst.ComputeStats)
10: THEN
11: dbms_output.put_line(' Compute Stats');
12: END IF;
7:
8: dbms_output.put_line('ODCIStatsOptions');
9: IF (so.Flags = ODCIConst.ComputeStats)
10: THEN
11: dbms_output.put_line(' Compute Stats');
12: END IF;
13: IF (so.Flags = ODCIConst.EstimateStats)
14: THEN
15: dbms_output.put_line(' Estimate Stats');
11: dbms_output.put_line(' Compute Stats');
12: END IF;
13: IF (so.Flags = ODCIConst.EstimateStats)
14: THEN
15: dbms_output.put_line(' Estimate Stats');
16: IF (so.Options = ODCIConst.PercentOption)
17: THEN
18: dbms_output.put_line(' Sample ' || so.Sample || ' Percent');
19: ELSE
14: THEN
15: dbms_output.put_line(' Estimate Stats');
16: IF (so.Options = ODCIConst.PercentOption)
17: THEN
18: dbms_output.put_line(' Sample ' || so.Sample || ' Percent');
19: ELSE
20: dbms_output.put_line(' Sample ' || so.Sample || ' Rows');
21: END IF;
22: END IF;
16: IF (so.Options = ODCIConst.PercentOption)
17: THEN
18: dbms_output.put_line(' Sample ' || so.Sample || ' Percent');
19: ELSE
20: dbms_output.put_line(' Sample ' || so.Sample || ' Rows');
21: END IF;
22: END IF;
23: IF (so.Flags = ODCIConst.Validate)
24: THEN
21: END IF;
22: END IF;
23: IF (so.Flags = ODCIConst.Validate)
24: THEN
25: dbms_output.put_line(' Validate');
26: END IF;
27:
28: END;