DBA Data[Home] [Help]

SYS.DBMS_XQUERYINT SQL Statements

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

Line: 101

         select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
Line: 104

         select SYS_XQ_PKSQL2XML(to_number(str), 2, 4) into xval from dual;
Line: 107

         select SYS_XQ_PKSQL2XML(to_number(str), 2, 33) into xval from dual;
Line: 110

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,10,0,0,181), 181, 10)
         into xval
         from dual;
Line: 115

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,9,0,0,181), 181, 9)
         into xval
         from dual;
Line: 120

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,8,0,0,181), 181, 8)
         into xval
         from dual;
Line: 125

         select SYS_XQ_PKSQL2XML(to_binary_float(str), 100, 5) into xval from dual;
Line: 128

         select SYS_XQ_PKSQL2XML(to_binary_double(str), 101, 6) into xval from dual;
Line: 131

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,52,0,0,189), 189, 52) into xval from dual;
Line: 134

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,51,0,0,190), 190, 51) into xval from dual;
Line: 137

         select SYS_XQ_PKSQL2XML(case SYS_XQ_ATOMCNVCHK(str,1,3) WHEN '0' THEN HEXTORAW('00')  ELSE HEXTORAW('01')  END, 23, 3) into xval from dual;
Line: 140

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,11,0,0,181), 181, 11) into xval from dual;
Line: 143

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,12,0,0,181), 181, 12) into xval from dual;
Line: 146

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,13,0,0,181), 181, 13) into xval from dual;
Line: 149

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,14,0,0,181), 181, 14) into xval from dual;
Line: 152

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,15,0,0,181), 181, 15) into xval from dual;
Line: 155

         select SYS_XQ_PKSQL2XML(str, 1,7) into xval from dual;
Line: 158

         select SYS_XQ_PKSQL2XML(str, 1,50) into xval from dual;
Line: 161

         select SYS_XQ_PKSQL2XML(SYS_XMLCONV(str,3,17,0,0,23), 23, 17) into xval from dual;
Line: 164

         select SYS_XQ_PKSQL2XML(HEXTORAW(str), 23, 16) into xval from dual;
Line: 167

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,34), 2, 34) into xval from dual;
Line: 170

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,35), 2, 35) into xval from dual;
Line: 173

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,36), 2, 36) into xval from dual;
Line: 176

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,37), 2, 37) into xval from dual;
Line: 179

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,38), 2, 38) into xval from dual;
Line: 182

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,39), 2, 39) into xval from dual;
Line: 185

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,40), 2, 40) into xval from dual;
Line: 188

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,41), 2, 41) into xval from dual;
Line: 191

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,42), 2, 42) into xval from dual;
Line: 194

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,43), 2, 43) into xval from dual;
Line: 197

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,44), 2, 44) into xval from dual;
Line: 200

         select SYS_XQ_PKSQL2XML(SYS_XQ_ATOMCNVCHK(to_number(str),2,45), 2, 45) into xval from dual;
Line: 203

         select SYS_XQ_PKSQL2XML(str, 1, 2) into xval from dual;
Line: 224

          select extract(xmltype.createxml(''||clb ||'',null,1,1),'/A/node()') into xval
          from dual;
Line: 239

       select sys_xqcon2seq(xval) into xval from dual;
Line: 242

     select sys_xqconcat(ret, xval) into ret from dual;
Line: 376

  select value into dbchr from v$nls_parameters where
      parameter = 'NLS_CHARACTERSET';
Line: 378

  select value into nlssrt from v$nls_parameters where
      parameter = 'NLS_SORT';
Line: 380

  select value into nlscmp from v$nls_parameters where
      parameter = 'NLS_COMP';