+1Hi,
I was wondering if there is any way to write from an Oracle Spatial Object to Excel, the following attributes:
- Column Names
- Data Types
- Nullable
- Triggers
- Dependencies
- Constraints
- Indexes
- SQL
and so on?
Perhaps this is more of a question of knowing in Oracle where these tables are stored?
I am using FME desktop 2018.1
Thanks,
+26This 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.
+15@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
+1Thank you both for your answers! They are both very helpful and exactly what I was looking for :)
