How we can see all the tables in one Schema?

Oracle db: We can see all tables in a scheme for curent user by using query 'select * from user_tables'. Dba user can see tables for all users by using query 'select * from all_tables'. Second query will return owner of table too.

There isn't an Oracle show tables command specifically, but the first method is using the dba_tables view. This view shows all of the tables in the database. select owner, table_name FROM dba_tables;