My account
Book a demo
Search
product
product
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Lineage
Reference Data Management
Report Catalog
Sensitive Data Discovery
Data Dictionary
Database Documentation
ER Diagrams
Schema Change Tracking
Supported
Technologies
See all features →
Solutions
Solutions
Metadata Management: Why Start Now?
By Use Case
Business Intelligence
Data Warehousing
Data Governance
Data Protection
Metadata Management
All Use Cases
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
All Industries
By Technology
SQL Server
Snowflake
Power BI
Azure
AWS
Supported Technologies
See all →
Pricing
Company
Why Dataedo?
About us
Careers
Our Customers
Case Studies
Testimonials
Contact Us
Resources
Resources
Dataedo Cartoons
General
Blog
Webinars
Videos
Library
Dataedo Cartoons
Dataedo
Documentation
Tutorials
Free trial
Download
Support
Contact support
Documentation
Tutorials
Free trial
Free trial
Product tour
Product tour
Ania
Database specialist with extensive experience in SQL Server and Oracle.
Contributors
Ania
Categories
All
Queries (34)
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
All Use Cases
