Oracle database

Database Design & Metadata

Test If Your Database Has Foreign Keys Or Is It Full of Loners (Metric + Test Queries)

Databases should but many don't have foreign key constraints. Does your database have them? To what extent? Here is a me...

Piotr Kononow 7 min read

Database Design & Metadata

What You Can Comment In Oracle Database

Overview of capabilities of commenting objects in Oracle database.

Piotr Kononow 3 min read

Database Design & Metadata

6 Useful Oracle Data Dictionary Queries Every DBA Should Have

List of handy SQL queries to the Oracle database data dictionary

Piotr Kononow 12 min read