List of "Tables, Views, Synonyms" in SQL

Hi.

I recently started using Oracle with BIOVIA Notebook, so I started studying SQL.
Ideally, we aim to be able to integrate BIOVIA Notebook and Pipeline Pilot through SQL.

As a starting point, I started investigating which parts of the Oracle DB are related to Notebook, but I'm struggling in front of a large number of tables. So could anyone create a protocol with the title feature for that research?

If there is a protocol to extract the name list of "Tables, Views, Synonyms", I am thinking of filtering by the inclusion of ELN.

I think the "SQL Select for Each Data" component is relevant. .. ..