TOAD 188.8.131.52, Windows.
I am comparing two schemas with a large number of objects, which uses the naming convention of
I want to filter table and view names which start with ‘T_%’ and ‘V_%’ (global table or global view) however, I want the underscore to be preserved rather than a wildcard (any single char), so need to escape it.
There is no option to provide an escape character in either
- Filters |Filter by Object Name
- Filters |Object Set | Load Rows To Grid | Like
In 2. I can edit the query, adding an escape char, e.g.
and Upper(object_name) like ‘T~_%’ escape '~'
But that gets removed.
As this object naming convention is quite common and Oracle supports wildcard escaping, don’t you think there should be an escape char option on both 1 and 2. above?
Also, shouldn’t this be an option elsewhere too? (grid filtering etc.)