Oracle DB 10g EX SQL - query the list of all tables in curent schema

SELECT * FROM tab;