Dear Experts,
May I know why I am getting an error of below SQL
SQL> select 'select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','''||USERNAME||''') from dual; 'from dba_users where username like 'SMS%';
select 'select DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','''||USERNAME||''') from dual; 'from dba_users where username like 'SMS%'
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
Thanks