SYS.DBMS_OBJECTS_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

execute immediate 'select bitand(flags, 128) from coltype$ where
obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)' into oldimg;

Line: 32

execute immediate 'select count(*) from kottd$' into origcnt;

Line: 33

execute immediate 'insert into kottd_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottd$';

Line: 36

execute immediate  'update coltype$ set flags=flags-bitand(flags,128)
where obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)';

Line: 42

execute immediate 'begin insert into kottd$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottd_temp$;

Line: 45

execute immediate 'delete from kottd$';

Line: 46

execute immediate 'begin insert into kottd$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottd_temp$;

Line: 49

execute immediate 'select count(*) from kottd$' into inscnt;

Line: 66

execute immediate 'insert into kottb_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottb$';

Line: 68

execute immediate 'select count(*) from kottb$' into origcnt;

Line: 70

execute immediate  'update coltype$ set flags=flags-bitand(flags,128)
where obj#=(select obj# from obj$ where name=''KOTTB$'' and owner#=0)';

Line: 74

execute immediate 'begin insert into kottb$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottb_temp$ ; exception when

Line: 77

execute immediate 'delete from kottb$';

Line: 78

execute immediate 'begin insert into kottb$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottb_temp$ ; exception when

Line: 81

execute immediate 'select count(*) from kottb$' into inscnt;

Line: 100

execute immediate 'insert into kottbx_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottbx$';

Line: 102

execute immediate 'select count(*) from kottbx$' into origcnt;

Line: 104

execute immediate  'update coltype$ set flags=flags-bitand(flags,128)
where obj#=(select obj# from obj$ where name=''KOTTBX$'' and owner#=0)';

Line: 107

execute immediate 'begin insert into kottbx$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottbx_temp$  ; exception when

Line: 111

execute immediate 'delete from kottbx$';

Line: 112

execute immediate 'begin insert into kottbx$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottbx_temp$  ; exception when

Line: 115

execute immediate 'select count(*) from kottbx$' into inscnt;

Line: 132

execute immediate 'insert into kotad_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotad$';

Line: 135

execute immediate 'select count(*) from kotad$' into origcnt;

Line: 136

execute immediate  'update coltype$ set flags=flags-bitand(flags,128)
where obj#=(select obj# from obj$ where name=''KOTAD$'' and owner#=0)';

Line: 140

execute immediate 'begin insert into kotad$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotad_temp$; exception when others

Line: 144

execute immediate 'delete from kotad$';

Line: 145

execute immediate 'begin insert into kotad$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotad_temp$; exception when others

Line: 148

execute immediate 'select count(*) from kotad$' into inscnt;

Line: 168

execute immediate 'insert into kotmd_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotmd$';

Line: 171

execute immediate 'select count(*) from kotmd$' into origcnt;

Line: 172

execute immediate  'update coltype$ set flags=flags-bitand(flags,128)
where obj#=(select obj# from obj$ where name=''KOTMD$'' and owner#=0)';

Line: 175

execute immediate 'begin insert into kotmd$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotmd_temp$; exception when others

Line: 178

execute immediate 'delete from kotmd$';

Line: 179

execute immediate 'begin insert into kotmd$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kotmd_temp$; exception when others

Line: 182

execute immediate 'select count(*) from kotmd$' into inscnt;

Line: 209

procedure delete_orphan_typeidcols
is

objno number;

Line: 217

select distinct c.obj#, c.intcol# from col$ c, coltype$ t where
bitand(c.property, 33554432)=33554432 and c.obj#=t.obj# and
c.intcol# not in (select typidcol# from coltype$ t1 where c.obj#=t1.obj# and
typidcol# is not null);

Line: 230

  DELETE from col$ where obj#=objno and intcol#=intcolno;

Line: 237

end; /* end of delete_orphan_typeidcols */

Line: 257

execute immediate 'select bitand(flags, 128) from coltype$ where
obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)' into oldimg;

Line: 272

execute immediate  'update coltype$ set flags=flags+128
where obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)';

Line: 277

execute immediate 'insert into kottd_temp$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottd$ where sys_nc_oid$=''00000000000000000000000000000044'' or sys_nc_oid$=''00000000000000000000000000000045'' or sys_nc_oid$=''00000000000000000000000000000046''';

Line: 280

execute immediate 'delete from kottd$ where sys_nc_oid$=''00000000000000000000000000000044'' or sys_nc_oid$=''00000000000000000000000000000045'' or sys_nc_oid$=''00000000000000000000000000000046''';

Line: 282

execute immediate  'update coltype$ set flags=flags-128
where obj#=(select obj# from obj$ where name=''KOTTD$'' and owner#=0)';

Line: 287

execute immediate 'insert into kottd$(sys_nc_oid$, sys_nc_rowinfo$)
select sys_nc_oid$, sys_nc_rowinfo$ from kottd_temp$ where sys_nc_oid$=''00000000000000000000000000000044'' or sys_nc_oid$=''00000000000000000000000000000045'' or sys_nc_oid$=''00000000000000000000000000000046''';