OWAPUB.OWA_OPT_LOCK SQL Statements

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

Line: 42

               'select column_name
                  from all_tab_columns
                 where owner = upper(:p_owner)
                   and table_name = upper(:p_tname)
                 order by column_id', dbms_sql.native);

Line: 59

                 l_theQuery := 'select owa_opt_lock.checksum(';

Line: 69

					' where rowid = :x1 for update';

Line: 92

						'select rowid, a.* from ' || p_owner || '.' || p_tname ||
						' a where rowid = :x1';

Line: 132

						'select * from ' ||
						 p_old_values(1) || '.' || p_old_values(2) ||
						' where rowid = :x1 for update';