DBA Data[Home] [Help]

SYS.ODCIINDEXALTEROPTIONDUMP dependencies on DBMS_OUTPUT

Line 3: dbms_output.put('Alter Option :');

1: PROCEDURE ODCIIndexAlterOptionDump(op NUMBER) IS
2: BEGIN
3: dbms_output.put('Alter Option :');
4: IF (op = ODCIConst.AlterIndexNone)
5: THEN
6: dbms_output.put_line(' None');
7: END IF;

Line 6: dbms_output.put_line(' None');

2: BEGIN
3: dbms_output.put('Alter Option :');
4: IF (op = ODCIConst.AlterIndexNone)
5: THEN
6: dbms_output.put_line(' None');
7: END IF;
8: IF (op = ODCIConst.AlterIndexRename)
9: THEN
10: dbms_output.put_line(' Rename');

Line 10: dbms_output.put_line(' Rename');

6: dbms_output.put_line(' None');
7: END IF;
8: IF (op = ODCIConst.AlterIndexRename)
9: THEN
10: dbms_output.put_line(' Rename');
11: END IF;
12: IF (op = ODCIConst.AlterIndexRebuild)
13: THEN
14: dbms_output.put_line(' Rebuild');

Line 14: dbms_output.put_line(' Rebuild');

10: dbms_output.put_line(' Rename');
11: END IF;
12: IF (op = ODCIConst.AlterIndexRebuild)
13: THEN
14: dbms_output.put_line(' Rebuild');
15: END IF;
16: IF (op = ODCIConst.AlterIndexRebuildOnline)
17: THEN
18: dbms_output.put_line(' Rebuild Online');

Line 18: dbms_output.put_line(' Rebuild Online');

14: dbms_output.put_line(' Rebuild');
15: END IF;
16: IF (op = ODCIConst.AlterIndexRebuildOnline)
17: THEN
18: dbms_output.put_line(' Rebuild Online');
19: END IF;
20: IF (op = ODCIConst.AlterIndexModifyCol)
21: THEN
22: dbms_output.put_line(' Modify Column');

Line 22: dbms_output.put_line(' Modify Column');

18: dbms_output.put_line(' Rebuild Online');
19: END IF;
20: IF (op = ODCIConst.AlterIndexModifyCol)
21: THEN
22: dbms_output.put_line(' Modify Column');
23: END IF;
24: IF (op = ODCIConst.AlterIndexUpdBlockRefs)
25: THEN
26: dbms_output.put_line(' Update Block References');

Line 26: dbms_output.put_line(' Update Block References');

22: dbms_output.put_line(' Modify Column');
23: END IF;
24: IF (op = ODCIConst.AlterIndexUpdBlockRefs)
25: THEN
26: dbms_output.put_line(' Update Block References');
27: END IF;
28: IF (op = ODCIConst.AlterIndexRenameCol)
29: THEN
30: dbms_output.put_line(' Rename Column ');

Line 30: dbms_output.put_line(' Rename Column ');

26: dbms_output.put_line(' Update Block References');
27: END IF;
28: IF (op = ODCIConst.AlterIndexRenameCol)
29: THEN
30: dbms_output.put_line(' Rename Column ');
31: END IF;
32: IF (op = ODCIConst.AlterIndexRenameTab)
33: THEN
34: dbms_output.put_line(' Rename Table ');

Line 34: dbms_output.put_line(' Rename Table ');

30: dbms_output.put_line(' Rename Column ');
31: END IF;
32: IF (op = ODCIConst.AlterIndexRenameTab)
33: THEN
34: dbms_output.put_line(' Rename Table ');
35: END IF;
36: IF (op = ODCIConst.AlterIndexMigrate)
37: THEN
38: dbms_output.put_line(' Migrate Index ');

Line 38: dbms_output.put_line(' Migrate Index ');

34: dbms_output.put_line(' Rename Table ');
35: END IF;
36: IF (op = ODCIConst.AlterIndexMigrate)
37: THEN
38: dbms_output.put_line(' Migrate Index ');
39: END IF;
40: END;