sqlplus

sqlplus scott/tiger@10.129.204.235/XE

# Will display the tables for current user
SELECT table_name FROM user_tables;
select * from EMP;
select * from DEPT;

# You will see all of the tables in the database
select table_name from all_tables;

# Will see the accessible tables for the user
SELECT owner, table_name FROM all_tables;

# Login as sysdba
sqlplus scott/tiger@10.129.204.235/XE as sysdba

select name, password from sys.user$;