As I ask in https://dba.stackexchange.com/q/280035/118215 , I have a table that stores sql code for reports named reports:
report_code PK VARCHAR 5
report_sql TEXT
And I want to search in it the reports codes (from column report_code that report_sql has sql_code that consumes views and materialized views that are generated from specific tables.
The table reports and both the views and the materialized views are located in the same server.
Top comments (0)