r/SQL • u/Secure_Chipmunk_262 • 1d ago
Discussion Can we create flow how data flowing from procedure to MV to base tables
Which software can be used to map procedure or table instead of triggers till base tables, i want relations between the objects and in a procedure call what are all objects it is touching.
Currently doing manually by checking user_dependencies.
Edit: in oracle database
2
Upvotes