View tables or views in Oracle

Check which tables or views are available in Oracle. 1. query which tables of the current user have the SQL code SELECT * FROM user_tables www.2cto.com. 2. query the current user, which tables can be accessed [that is, access to yourself and other users] SQL code SELECT * FROM all_tables 3. query all tables in the current database, you must have the DBA permission. SELECT * FROM dba_tables 4. query all objects of the current user. select * from tab; 5. view SQL code select view_name from user_views.