This information can be found in the Oracle data dictionary tables.

Use the Non Spatial reader and read from:

USER_TAB_COLUMNS (for column information)

USER_TRIGGERS (for triggers)

USER_CONSTRAINTS (for dependencies and constraints)

USER_INDEXES and USER_IND_COLUMNS (for indexes)

And more tables/views are available.

Replace USER with ALL if you need information from other schema objects (those tables/views will contain an OWNER attribute).

Hope this helps.

@aquamarine

Yes it is a Oracle sql question. And there are a lot of good answers

There are for instance (for users) user_tables, user_tab_columns, user_constraints etc.

user and dba versions are dependent on your privileges.

all_triggers and all_constraints are independent of your privileges.

For instance to find info on 'yourtable' and you have relevant privilges:

select user_columns,constraint_name, constraint_type

from user_constraints uc,user_tab_columns utc

where table_name = 'yourtable'

and utc.TABLE_NAME =uc.TABLE_NAME

Thank you both for your answers! They are both very helpful and exactly what I was looking for :)