I am looking for the equivalent oracle query that I use to do on Informix to list all of the tables from a specific company. An example of the informix command was "SELECT tabname FROM systables WHERE tabname LIKE 'tt*999'. That Informix query would list all tables from company 999. What is the equivalent oracle table name which contains all of the table names and what is the field name for the table name. If you could provide the entire SQL query so I can just cut and past that would be appreciated. Thanks.

Hi,

select table_name from all_tables where table_name like '%999'

Al.

Thanks - that is what I was looking for.