Sql scratchpad11/22/2023 ![]() ![]() Reporting capability, create DDL script, export view to MS-Excel, create various administration script.Yellow cell background when grantee has a private synonym for the object.Cross-table display of objects in schema, grantees (users and roles), and granted privileges.Detailed table and column statistics view including statistics preferences.View current table access and manage auditing.Data content view opens a data browser for the current table similar to the Data Content Browser including additional Master/Detail view.Object dependency view shows objects that depend on or are dependent of the current table or view.Master/detail table diagram shows ER diagram detail view for the current table and allows you to navigate tables along referential integrity.Manage public and private synonyms for the table or view.Manage table and column privileges and show grantees and privileges in cross-table matrix.Manage table and index partitions including subpartitions.Wizards to create instead-of triggers for views, mutating table compound triggers and triggers to set primary key value from sequence.Create and edit triggers with syntax and PL/SQL error highlighting.Show exceptions for disabled or not validated constraint (data that violates).Show indexes that support the constraint columns. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |