My account
Ania - Dataedo Team

Ania

Database specialist with extensive experience in SQL Server and Oracle.

Categories
Query Toolbox
Oracle database > Foreign keys: Find tables without relationships - Loner Tables - in Oracle database
Oracle database > Foreign keys: Find tables without foreign keys in Oracle database
Oracle database > Foreign keys: List tables with most foreign keys in Oracle database
2019-06-04
Query Toolbox
Oracle database > Triggers: List triggers in Oracle database
Oracle database > Triggers: List table triggers in Oracle database
Oracle database > Primary keys: How many tables don't have primary keys in Oracle database (with percentage)
2019-02-04
Query Toolbox
Oracle database > Data types: Find tables with large object (LOB) data type columns in Oracle database
Oracle database > Data types: Find large object (LOB) data type columns in Oracle database
Oracle database > Views: List materialized views in Oracle database
2018-12-31
Query Toolbox
Oracle database > Searching schema: Find tables that DON'T have column with a specific name in Oracle database
Oracle database > Searching schema: Find tables with a specific column name in Oracle database
Oracle database > Searching schema: Find tables with digits in their names in Oracle database
Oracle database > Searching schema: Find tables with names with the specific suffix in Oracle database
Oracle database > Searching schema: Find tables with a specific word in name in Oracle database
Oracle database > Searching schema: Find tables with names with the specific prefix in Oracle database
Oracle database > Searching schema: Find table by name in Oracle database
2018-12-14
Query Toolbox
Oracle database > Tables: Find recently created tables in Oracle database
2018-12-07
Query Toolbox
Oracle database > Schema statistics: Average number of columns per table in Oracle database
Oracle database > Schema statistics: List tables with the largest number of columns in Oralce database
Oracle database > Schema statistics: Find the number of columns in tables in Oracle database
Oracle database > Schema statistics: Find the number of tables in Oracle database
Oracle database > Indexes: List all indexes in Oracle database
Oracle database > Constraints: Find required (non nullable) columns in Oracle database
Oracle database > Default values: List table default values in Oracle database
Oracle database > Columns: List all columns in specific table in Oracle database
2018-11-28
Query Toolbox
Oracle database > Columns: List table columns in Oracle database
Oracle database > Views: List tables used by a view in Oracle database
Oracle database > Schema naming: List columns by name length in Oracle database
Oracle database > Schema naming: Get column name length distribution in Oracle database
2018-11-26
Query Toolbox
Oracle database > Schema naming: Find most popular column names in Oracle database
2018-10-08
Query Toolbox
Oracle database > Views: List views columns in Oracle database
2018-07-05
Query Toolbox
Oracle database > Views: List views in Oracle database with their scripts
Oracle database > Views: List views in Oracle database
2018-07-04
Query Toolbox
Oracle database > Databases and schemas: List schemas in Oracle database
2018-06-27