CODEWITHSUNDEEP
sqloracle-database
Julio Arboleda
Julio Arboleda

Reputation: 1

Given a set of SQL queries, how do I list all the required tables and fields?

I have about 400 separate SQL files, each with is own select into my database. I want to list the tables and columns from where they extract the information.

I was thinking to upload them to my testing database and then use some system table to get the metadata. Not sure if this would be the better approach.

Upvotes: 0

Views: 54

Answers (1)

Radagast81
Radagast81

Reputation: 3016

Yeah, I would also create views with the corresponding sql and then use DBA_DEPENDENCIES to extract the used database objects.

Upvotes: 2

Related Questions