Analyzing Keywords in Enron’s Email

You probably can’t read all the 252K email messages in the Enron email dataset by yourself.

But with SQL it’s easy to search for keywords, like “Special Purpose Entity”, “Bankrupt”, “Fraud”, “Shutdown”, “Talking Points”, “FERC” and so on. They begin to reveal what really went on inside the minds at Enron.

Continue Reading →

Very Useful Scripts To Find Object Dependencies

Very Useful Scripts To Find Oracle Object Dependencies; Parents, and Children.

Fabulous to determine:
– The order of operations to create objects. Parents first. Then children.
– The impact of dropping a view, package, procedure.
– Causes of object invalidation such as another invalid object.
– ALL the tables that a package is accessing.
– Whether a package, function or procedure calls another prodecure.
– Obscure issues, such as references to variables in packages.

Continue Reading →