I'm not sure what an Advantage database is, but you can query the INFORMATION_SCHEMA `tables` system view which returns a list of all tables on the server instance. You can narrow the select by specifying table_schema or table_name in your WHERE clause. There's any number of ways to code this statement. Here is one example:

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.