MDSYS.SDO_RELATE_MASK SQL Statements

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

Line: 2

procedure insert_mask(mask      in varchar2,
                      relation  in varchar2) is
begin
  insert into md$relate values(mask,nls_upper(relation),user);

Line: 7

end insert_mask;

Line: 9

procedure update_mask(mask      in varchar2,
                 relation  in varchar2) is
owner varchar2(30);

Line: 13

  select definer into owner from md$relate where sdo_mask=mask;

Line: 18

  update md$relate set sdo_relation=nls_upper(relation) where sdo_mask=mask;

Line: 20

end update_mask;

Line: 22

procedure delete_mask(mask      in varchar2) is
owner varchar2(30);

Line: 25

  select definer into owner from md$relate where sdo_mask=mask;

Line: 30

  delete from md$relate where sdo_mask=mask;

Line: 32

end delete_mask;