sales@dataedo.com
+1 609-849-3393
My account
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
Book a demo
Product tour
Database Data Dictionary Query Toolbox
Oracle database Data Dictionary Query Toolbox
Databases and schemas
List schemas in Oracle database
Tables
List tables in Oracle database
List tables in Oracle schema
Find recently created tables in Oracle database
Find recently modified tables in Oracle database
Columns
List table columns in Oracle database
List all columns in specific table in Oracle database
List all computed columns in Oracle database
Views
List views in Oracle database
List views in Oracle database with their scripts
List views columns in Oracle database
List tables used by a view in Oracle database
List materialized views in Oracle database
Primary keys
List all primary keys (PKs) in Oracle database
List all primary keys (PKs) and their columns in Oracle database
List tables with their primary keys (PKs) in Oracle database
Find tables without primary keys (PKs) in Oracle database
How many tables don't have primary keys in Oracle database (with percentage)
Foreign keys
List tables with most foreign keys in Oracle database
Find tables without foreign keys in Oracle database
Find tables without relationships - Loner Tables - in Oracle database
Check constraints
List all check constraints on tables in Oracle database
List table check constraints in Oracle database
Default values
List table default values in Oracle database
Constraints
Find required (non nullable) columns in Oracle database
Check if is column nullable in Oracle database
Indexes
List all indexes in Oracle database
List indexes on the table in Oracle database
List unique indexes in Oracle database
Data types
Find all numeric columns in Oracle database
Find all character (string) columns in Oracle database
Find all date and time columns in Oracle database
Find all spatial data columns in Oracle database
Find all XML data columns in Oracle database
Find all JSON data columns in Oracle database
Find large object (LOB) data type columns in Oracle database
Find tables with large object (LOB) data type columns in Oracle database
Triggers
List triggers in Oracle database
List table triggers in Oracle database
Functions and stored procedures
List user defined functions (UDFs) in Oracle database
List stored procedures in Oracle database
List stored procedure arguments in Oracle database
Jobs/events
List scheduled jobs in Oracle database
Dependencies
List objects that use specific object in Oracle database
Find tables and views used by specific view in Oracle database
Find objects used by specific function in Oracle database
Find objects used by specific stored procedure in Oracle database
Find where specific table or view is used in Oracle database
Find where specific function is used in Oracle database
Find where specific stored procedure is used in Oracle database
Find tables that are not used by any other object
List tables used by Materialized Views (MV dependencies) in Oracle database
Searching schema
Find table by name in Oracle database
Find tables with names with the specific prefix in Oracle database
Find tables with a specific word in name in Oracle database
Find tables with names with the specific suffix in Oracle database
Find tables with digits in their names in Oracle database
Find tables with a specific column name in Oracle database
Find tables that DON'T have column with a specific name in Oracle database
Schema statistics
Find the number of tables in Oracle database
Find the number of columns in tables in Oracle database
List tables with the largest number of columns in Oralce database
Average number of columns per table in Oracle database
Schema naming
Find most popular column names in Oracle database
Get column name length distribution in Oracle database
List columns by name length in Oracle database
Security and users
List users in Oracle database
Session
List sessions / active connections in Oracle database
Terminate (kill) specific session on a server
Environment
How to check Oracle Database version
How to find operating system (OS) that Oracle database runs on
Number of rows
List tables by the number of rows in Oracle database
Find empty tables in Oracle database
Number of tables by the number of rows in Oracle database
Schema compare
Compare tables and columns in two schemas in Oracle database
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please
accept statistics cookies
.
0
There are no comments.
Click here
to write the first comment.
Please enable JavaScript to view the
comments powered by Disqus.