SYS.SQLJUTL SQL Statements

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

Line: 15

           select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
           WHERE OBJECT_NAME = proc AND OWNER = l_owner
           AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME is NULL;

Line: 19

           select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
           WHERE OBJECT_NAME = proc AND OWNER = l_owner
           AND SEQUENCE = seq  and OVERLOAD = ovr and PACKAGE_NAME IS NULL;

Line: 26

           select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
           WHERE OBJECT_NAME = proc AND OWNER = l_owner
           AND SEQUENCE = seq and OVERLOAD is NULL and PACKAGE_NAME = pkg_nm;

Line: 30

           select upper(DEFAULTED) INTO def FROM ALL_ARGUMENTS
           WHERE OBJECT_NAME = proc AND OWNER = l_owner
           AND SEQUENCE = seq  and OVERLOAD = ovr and PACKAGE_NAME = pkg_nm;

Line: 57

      SELECT typecode, externname, externtype INTO code, class, typ
      FROM TYPE$ WHERE toid = tid;

Line: 63

        SELECT max(version#) INTO m FROM TYPE$ WHERE toid = tid;

Line: 64

        SELECT typecode, externname, externtype INTO code, class, typ
        FROM TYPE$ WHERE toid = tid AND version# = m;