Connect programmer/p@9i
Set ServerOutput On Size 10000
 
Connect observer/p@9i
select * from open_cursor_sql_text
  order by sql_text
/

/*
BEGIN DBMS_OUTPUT.ENABLE(10000); END;
*/
-- use values for department_id from

-- ( 10, 20, 30, 40, 50, 60, 70, 80, 90, 100, 110 )
-- for example...
begin Show_Rows_For_Dept_Static_Sql ( 10 ); end;
/
/*
Whalen
*/


begin Show_Rows_For_Dept_Static_Sql ( 90 ); end;
/
/*
King
Kochhar
De Haan
*/

-- repeat the query after each successive Show_Rows_For_Dept_Static_Sql
/
/*
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
SELECT last_name from employees where department_id = :b1
begin Show_Rows_For_Dept_Static_Sql ( 90 ); end;
*/