Using LIKE operator in Enterprise Manager Cloud Control 12c
edited Jun 13, 2013 5:39AM in Managing Databases using Enterprise Manager (MOSC) 2 commentsAnswered ✓
I've searched the forums and been unable to find the proper syntax to use in Enterprise Manager
to run a SQL statement across multiple databases statement such as:
SELECT * from ALL_USERS where username LIKE '%TOM%';
The command works as expexted in PL/SQL but in Enterprise Manager returns the error:
" An error occurred while submitting the job: Invalid target property: %TOM%. "
Any guidance would be appreciated.
0