Is there a way to get a resultset from executing a query against an Oracle database that would return a listing of all the tables in the database and which sequence it is using (if any)?
You can query with this one:
SELECT TABLE_OWNER, TABLE_NAME, REFERENCED_OWNER AS SEQUENCE_OWNER, REFERENCED_NAME AS SEQUENCE_NAME FROM ALL_DEPENDENCIES d JOIN ALL_TRIGGERS t ON TRIGGER_NAME = d.NAME AND t.OWNER = d.OWNER WHERE REFERENCED_TYPE = 'SEQUENCE';
Note, a sequence might be used by more than one trigger. And a sequence can be used also by function, procedure, package, insert, update, etc, which is not covered by this query.
Also this query does not cover
IDENTITY columns and sequences, they are hidden.
It depends what you mean by "identify sequences used by tables"?