SYS.PRVTPARENTCHILD SQL Statements

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

Line: 42

    sqlStmt := ' select count(*) ' || sqlStmtBase;

Line: 45

        sqlStmt := 'select ct.sys_nc_oid$ ' || sqlStmtBase;

Line: 48

        sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';

Line: 93

       select count(*) INTO counter from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;

Line: 95

          select rg.sys_nc_oid$ INTO elementID from xdb.xdb$group_ref rg, xdb.xdb$group_def dg where ref(dg) = rg.xmldata.groupref_ref and dg.sys_nc_oid$= groupID;

Line: 102

      sqlStmt := ' select count(*) ' || sqlStmtBase;

Line: 105

           sqlStmt := ' select sm.sys_nc_oid$ ' || sqlStmtBase;

Line: 111

      sqlStmt := ' select count(*) ' || sqlStmtBase;

Line: 115

           sqlStmt := ' select sm.sys_nc_oid$ ' || sqlStmtBase;

Line: 121

      sqlStmt := ' select count(*) ' || sqlStmtBase;

Line: 124

           sqlStmt := ' select sm.sys_nc_oid$ ' || sqlStmtBase;

Line: 138

    sqlStmt := ' select count(*) ' || sqlStmtBase;

Line: 142

        sqlStmt := 'select ct.sys_nc_oid$ ' || sqlStmtBase;

Line: 145

        sqlStmt := ' select hextoraw(e.xmldata.property.prop_number) from xdb.xdb$element e where sys_op_r2o(e.xmldata.property.type_ref) = ';

Line: 179

            sqlStmt := 'select count(*) from xdb.xdb$choice_model sm, ' || sqlStmtBase;

Line: 182

              sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$choice_model sm, ' || sqlStmtBase;

Line: 186

              sqlStmt := 'select count(*)   from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

Line: 189

                 sqlStmt := 'select sm.sys_nc_oid$  from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

Line: 193

                 sqlStmt := 'select count(*)  from xdb.xdb$all_model sm, ' || sqlStmtBase;

Line: 196

                    sqlStmt := 'select sm.sys_nc_oid$   from xdb.xdb$all_model sm, ' || sqlStmtBase;

Line: 229

       select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$choice_model sm,
       table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;

Line: 232

           select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$choice_model sm, table(sm.xmldata.elements)t where
           ref(e) = t.column_value and e.xmldata.property.prop_number =  elementID ;

Line: 237

          select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$sequence_model sm,
          table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number = elementID ;

Line: 240

            select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$sequence_model sm, table(sm.xmldata.elements)t where
            ref(e) = t.column_value and e.xmldata.property.prop_number =  elementID ;

Line: 245

            select count(*) INTO counter from xdb.xdb$element e, xdb.xdb$all_model sm,
            table(sm.xmldata.elements)t where ref(e) = t.column_value and e.xmldata.property.prop_number =  elementID ;

Line: 248

                select sm.sys_nc_oid$ INTO modelID from xdb.xdb$element e, xdb.xdb$all_model sm, table(sm.xmldata.elements)t where
                ref(e) = t.column_value and e.xmldata.property.prop_number =  elementID ;

Line: 267

            sqlStmt := 'select count(*) from xdb.xdb$choice_model sm, ' || sqlStmtBase;

Line: 270

              sqlStmt := 'select sm.sys_nc_oid$ from xdb.xdb$choice_model sm, ' || sqlStmtBase;

Line: 274

              sqlStmt := 'select count(*)   from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

Line: 277

                 sqlStmt := 'select sm.sys_nc_oid$  from xdb.xdb$sequence_model sm, ' || sqlStmtBase;

Line: 281

                 sqlStmt := 'select count(*)  from xdb.xdb$all_model sm, ' || sqlStmtBase;

Line: 284

                    sqlStmt := 'select sm.sys_nc_oid$   from xdb.xdb$all_model sm, ' || sqlStmtBase;

Line: 294

                    sqlStmt := 'select count(*) ' || sqlStmtBase;

Line: 297

                       sqlStmt := 'select sm.sys_nc_oid$ ' || sqlStmtBase;