slow query

use the following when testing something that requires a slow query.

http://www.jlcomp.demon.co.uk/deterministic.html

create or replace function wait_row(
i_v in varchar2,
i_sec in number default 5 ) return varchar2
deterministic
parallel_enable as
begin
sys.dbms_lock.sleep(i_sec);
return i_v;
end;
/