OWAPUB.OWA_UTIL SQL Statements

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

Line: 30

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

Line: 63

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

Line: 100

             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: 203

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

Line: 411

            colTbl.delete;

Line: 670

                        'select column_name, data_type '||
                           'from all_tab_columns '||
                           'where table_name = '''||upper(table_resolved)||''' '||
                           '  and owner = '''||upper(owner_resolved)||''' '||
                           'order by column_id',
                        dbms_sql.v7);

Line: 725

                       'select column_name, data_type, '||
                           '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: 850

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

Line: 1039

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

Line: 1148

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

Line: 1649

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

Line: 1873

	    selected     varchar2(2000);

Line: 1877

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

Line: 1884

	        dbms_sql.column_value( p_theCursor, 3, selected );

Line: 1885

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

Line: 1889

	    htp.formSelectClose;

Line: 1912

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

Line: 1914

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

Line: 1919

		htp.formSelectClose;

Line: 1921

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

Line: 1923

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

Line: 1928

		htp.formSelectClose;

Line: 1930

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

Line: 1932

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

Line: 1937

		htp.formSelectClose;