PLsql voorbeeldjes

Cursor en doorlopen cursor en uitvoeren

set echo on
set serveroutput on format wrapped

declare
  cursor c_syn
  is
  select table_name
  from all_tables
  where owner = 'DWH_DM'
  and table_name  like 'POP%';
begin
 
  for r_syn in c_syn
  loop
    dbms_output.put_line ( 'grant select on '||r_syn.table_name||' to ERISA_BO');
    execute immediate 'grant select on '||r_syn.table_name||' to ERISA_BO' ;
  end loop; 

end;
/