sql query to check for a table with an expression

[Sunitha Mudidani]

Hi,

I need to know the table names that end with some expression like "_EXP" in a schema.

what is the query for that ?

Thanks
Sunitha

[Agador Paloi]

Sunitha ,

The query would be :

SELECT table_name
FROM user_tables
where table_name like '%_EXP';


-Agad