Search results for query: *

I have a report with the parameter :qry_mth with the following SQL populating the field: select distinct to_char(entered,'MON YYYY') as entry_dt from t_trans order by to_date(entry_dt,'MM/YY') The problem is that when the report is selected from a menu the list of values does not appear as a...

Hi, I am relatively new to Oracle, can anyone help with this? I created a report based on a table created in the Before Parameter Form trigger(it is populated in the After Parameter Form trigger). I have 2 problems, I have to compile the report every time I open it in Report Builder. The second...

hi nagornyi Thanks again for the assistance with do_sql. I have another question this time with Oracle Reports Developer. Is it possible to create a report based on a varray? And if it is how do you go about building it?

Thank you very much, I tried it and it worked.

How do you include a variable in a select into statement enclosed in srw.do_sql() srw.do_sql('select count(emp_id) into ' || v_ct || ' from table1 t1, table2 t2 where trunc(t1.date_entered) = ''12-MAR-07'' and t1.test = t2.test_link'); the...

I am new to oracle so my questions may seem very basic. I did try it but used GLOBAL TEMPORARY TABLE instead, should that matter?

Is it possible to use multiple tables in the select statement when creating tables?

Is is possible to use tablename.fieldname%TYPE when creating a table?

Hi everyone, I am new to Oracle and Oracle Reports Developer. I need to create a temporary table and populate it with some data, leaving 2 columns without data. These 2 columns will be populated by going through each row and checking other tables to see if there is related data for that row...