XDB.DBMS_XDBT SQL Statements

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

Line: 253

  SELECT spw_word BULK COLLECT INTO wordset
  FROM ctx_stopwords
  WHERE spw_stoplist = 'DEFAULT_STOPLIST' and
        spw_owner = 'CTXSYS';

Line: 422

  SELECT e.xmldata.author, e.xmldata.dispname,
         e.xmldata.rescomment, e.xmldata.contype,
         CASE WHEN e.xmldata.xmlref IS NOT NULL
              THEN DEREF(e.xmldata.xmlref).getclobval()
              ELSE NULL END,
         e.xmldata.xmllob, e.xmldata.charset,e.xmldata.ownerid,
         e.xmldata.creatorid, e.xmldata.lastmodifierid, e.xmldata.resextra
  INTO
         author, dispname, rescomment, contype, xmlref_lob, xmllob,
         charset, owneridr, creatoridr, lastmodidr, resextra

  FROM xdb.xdb$resource e
  WHERE ROWID = rid;

Line: 541

  SELECT COUNT(*) INTO pendingCount
  FROM ctx_user_pending
  WHERE pnd_index_name = DBMS_ASSERT.SIMPLE_SQL_NAME(iname);