Oracle grant select on schema

BEGIN
   FOR R IN (SELECT owner, table_name FROM all_tables 
             WHERE owner='OTHER_SCHEMA') LOOP
      EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
                         R.owner || '.' || R.table_name || ' TO MY_SCHEMA';
   END LOOP;
END;

Similar codes

0 vote97 views2 answers
Avg() sql
SQL
0 vote124 views2 answers
Get top 1 row of each group
SQL
0 vote136 views3 answers
Select random sql
SQL
1 vote139 views1 answer
Set autoincrement to 0
SQL
0 vote154 views1 answer
Sqlite version check
SQL
2 votes185 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote147 views1 answer
Round one decimal place mysql
SQL
10 votes146 views2 answers
SQL rounding numbers
SQL
0 vote133 views1 answer
Select from column mysql
SQL
0 vote137 views2 answers
Tsql row number
SQL