List of all tables in Oracle DB

User_BC3L1

Where can I find a list of all tables? I need to write a query of all employees with all the benefits they have selected.

Madhwal.17

select * from tab

where tabtype='TABLE'

this query lists all the tables in your schema

dvohra21

Please refer https://chartio.com/resources/tutorials/how-to-list-all-tables-in-oracle/