jeudi 18 décembre 2014

Enumerate Oracle tables in PLSQL


How do you run a query to list all tables, or all tables where tableName like '%abc%'.


Just poking around, I tried the following with no success:



select * from SYS.TAB$
select * from SYS.OBJ$ where Name like '%abc%'


I'm trying to re-learn in Oracle some basic things I know in MSSQL.





Aucun commentaire:

Enregistrer un commentaire