SYS.OWA_OPT_LOCK SQL Statements

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

Line: 21

             select count(*)
               into :found
               from all_objects
             where owner = :p_schema
             and object_name = :p_obj;

Line: 127

               'select column_name, data_type
                  from all_tab_columns
                where owner = :p_schema
                and table_name = :p_obj
                order by column_id', dbms_sql.native);

Line: 146

             l_theQuery := 'select owa_opt_lock.checksum(';

Line: 165

                    ' where rowid = :x1 for update';

Line: 198

      l_theQuery := 'select rowid, a.* from ' || DBMS_ASSERT.ENQUOTE_NAME(p_schema) || '.' || DBMS_ASSERT.ENQUOTE_NAME(p_obj) ||
                  ' a where rowid = :x1';

Line: 244

      l_theQuery := 'select * from ' || DBMS_ASSERT.ENQUOTE_NAME(p_schema) || '.' || DBMS_ASSERT.ENQUOTE_NAME(p_obj) ||
                    ' where rowid = :x1 for update';