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