drop table my_tab;
create table my_tab as select object_id from all_objects fetch first 100 rows only;
select * from my_tab;

with 
function 
  getrand(pval in number) return number is 
begin 
  return round(dbms_random.value(0,20)); 
end; 
 
my_rnd as 
  ( 
    select object_id, getrand(object_id) getrnd from my_tab   --- using my_tab table created earlier 
  ) 
 
--select * from my_rnd where getrnd = 10; 
select object_id, getrnd from my_rnd where getrnd = 10;