Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
-- NoelReceived on Tue Feb 10 2004 - 06:37:23 CST