Re: Who is this called

Kurt-Erich.Finger_at_hte-company.de wrote:
> Hallo,
> I would have searched google if I would know how this statement is
> called.
> I searched the SQL reference but could not find it.
> I use it but I don't know the term.
>
>
> select 'GRANT SELECT ON '||view_name||' to USER_ROLE ;'
> from ALL_VIEWS
> where owner = 'MYSELF'
> and view_name != 'SYSTEM'
> order by view_name ;
>
> best regards
> ke

Depends on the tool.

If I were in SQL*Plus I would just paste it into the command line and hit the Enter key.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)