Here is the sample query to get all the tables in Oracle fusion.
SELECT table_name
FROM all_tables
WHERE owner = 'FUSION';
