Re: SQL Quest...

> SELECT *
> FROM ALL_OBJECTS
> WHERE OBJECT_NAME LIKE 'TAB/_%' ESCAPE '/';
>
> should do the trick...

It did the trick, but, but...
It returns no rows since...

SELECT *
    FROM ALL_OBJECTS
WHERE OBJECT_NAME LIKE 'TAB%'
AND INSTR(OBJECT_NAME, CHR(95)) > 0; -- used also '_' instead of CHR(95)

returns 4 objects:

OWNER                          OBJECT_TYPE        OBJECT_NAME
------------------------------ ------------------ -------------------
SYS                            VIEW               TABLE_PRIVILEGES
SYS                            TABLE              TABLE_PRIVILEGE_MAP
PUBLIC                         SYNONYM            TABLE_PRIVILEGES
PUBLIC                         SYNONYM            TABLE_PRIVILEGE_MAP

--
Noel