SYS.OWA_UTIL SQL Statements

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

Line: 61

             select 1
               into :found
               from all_tables
              where table_name = upper(:item_name)
                and owner      = upper(:item_owner);

Line: 94

             select 1
               into :found
               from all_views
              where view_name = upper(:item_name)
                and owner     = upper(:item_owner);

Line: 131

             select table_name, table_owner, db_link
               into :name, :owner, :db_link
               from all_synonyms
              where synonym_name = upper(:csynonym)
                and        owner = upper(:cschema);

Line: 242

         'select line, text
            from all_source
           where name  = upper(:n)
             and owner = upper(:o)
           order by type, line', dbms_sql.v7);

Line: 486

            colTbl.delete;

Line: 775

                      'select column_name, data_type, character_set_name '||
                           'from all_tab_columns '||
                           'where table_name = :t '||
                           '  and owner = :o '||
                           'order by column_id',
                        dbms_sql.v7);

Line: 841

                       'select column_name, data_type, character_set_name, '||
                           'decode(column_name'||col_decode||') '||
                           'from all_tab_columns '||
                           'where table_name = '''||upper(table_resolved)||''' '||
                           '  and owner = '''||upper(owner_resolved)||''' '||
                           '  and column_name in ('||col_in_clause||') '||
                           'order by 3',
                        dbms_sql.v7);

Line: 974

                        'select '||ccolumns||' from '||ctable||' '||cclauses,
                        dbms_sql.v7);

Line: 1195

                     'select '||ccolumns||' from '||ctable||' '||cclauses,
                     dbms_sql.v7);

Line: 1307

             'select column_name from all_tab_columns where table_name = upper(:t)
                 and owner = upper(:o)',
             dbms_sql.v7);

Line: 1862

	    if ( upper( substr( ltrim( theQuery ), 1, 6 ) ) <> 'SELECT' ) then
	        raise INVALID_QUERY;

Line: 2123

	    selected     varchar2(2000);

Line: 2140

            dbms_sql.define_column(p_theCursor, 3, selected, 2000);

Line: 2144

            htp.formSelectOpen( cname => p_cname,
                   nsize => p_nsize,
                   cattributes => ite( p_multiple,'multiple',NULL));

Line: 2153

                  dbms_sql.column_value( p_theCursor, 3, selected );

Line: 2154

                  htp.formSelectOption( cvalue => nc_visible,
                     cselected => ite( selected IS NULL, NULL, 'select'),
                     cattributes => 'value="' || nc_value || '"' );

Line: 2160

                  dbms_sql.column_value( p_theCursor, 3, selected );

Line: 2161

                  htp.formSelectOption( cvalue => visible,
                    cselected => ite( selected IS NULL, NULL, 'select'),
                    cattributes => 'value="' || value || '"' );

Line: 2166

	    htp.formSelectClose;

Line: 2189

	    htp.formSelectOpen( cname => p_name, nsize => 1 );

Line: 2191

	        htp.formSelectOption( cvalue => i,
	                              cselected => ite( i=l_day, 'selected', NULL ),
	                              cattributes => 'value="' ||
											ltrim(to_char(i,'00')) || '"' );

Line: 2196

		htp.formSelectClose;

Line: 2198

	    htp.formSelectOpen( cname => p_name, nsize => 1 );

Line: 2200

	        htp.formSelectOption( cvalue => to_nchar( to_date( i, 'MM' ), N'MON' ),
	                              cselected => ite( i=l_mon, 'selected', NULL ),
	                              cattributes => 'value="' ||
											ltrim(to_char(i,'00')) || '"' );

Line: 2205

		htp.formSelectClose;

Line: 2207

	    htp.formSelectOpen( cname => p_name, nsize => 1 );

Line: 2209

	        htp.formSelectOption( cvalue => i,
	                              cselected => ite( i=l_year, 'selected', NULL ),
	                              cattributes => 'value="' ||
											ltrim(to_char(i,'0000')) || '"' );

Line: 2214

		htp.formSelectClose;