Is there a Perl module that automatically grabs foreign key dependencies between Oracle tables?
Does anyone know if there is a Perl module that once provided a schema or table would scan the Oracle database for all related tables based on foreign keys and put them in a hash for further processing?
Something like this, for example: table 1 = sex, sex_id fields + description table 2 = person, person_id field + sex_id + other fields
The code would create a hash that includes the key for sex_id, indicating sex in sex. etc.
+3
source to share
1 answer
DBIx :: Class :: Schema :: Loader should do the trick, although I haven't tried it with Oracle, it is listed as supported in the docs and works great for mysql for me.
+1
source to share