Oracle (View all tables)

select * from dict;

OR

select TABLE_NAME from ALL_ALL_TABLES;

How do I know the version of Oracle 8i DB I've installed

Select * from v$version;