Skip to content
Rodgers Notes
Rodger Lepinsky, Database Expert, Data Analyst, Data Scientist.
  • Data Modeling
    • testpage_4
  • Database Tuning
  • Database Administration
  • Blog
  • Contact
    • About Rodger Lepinsky

Tag: Order Of Operations

The Parents And The Order Of Operations

December 29, 2011 Rodgers Notes Writer 2 Comments

What if some of your objects require parent objects 10 layers deep first? ie: type, table, function, view, synonym, package, procedure, etc. All_Dependencies only goes one layer deep.

Here is a very complex script to find all the successive parents of an object.

Continue Reading →

Posted in: Power Scripts Filed under: All_Dependencies, Oracle DBA Subjects, Order Of Operations, Scripts, SQL
  • Architecture
  • Cartesian Products
  • Data Science
  • Database Design Mistakes to Avoid
  • Design
  • Graph Database
  • Humour
  • Oracle Applications
  • Oracle DBA Subjects
  • Power Scripts
  • Quality
  • R
  • Reviews
  • Science
  • Security
  • SQL
  • SQL Server
  • Tuning
  • Uncategorized
  • Uniface
  • Unix and Linux
  • Windows
Copyright © 2026 Rodgers Notes — Velux WordPress theme by GoDaddy