filmov
tv
Automatic CRUD Matrix Generation for Oracle Database PL/SQL Code
![preview_player](https://i.ytimg.com/vi/J_PYIo9O_SQ/sddefault.jpg)
Показать описание
Check out how Visual Expert empowers Oracle PL/SQL coders with efficient code analysis here:
Learn how to generate a CRUD matrix using Visual Expert with just a few clicks, showing which Oracle Objects access your data, and how. For example, which Procedures Create/Read/Update/Delete which Tables.
You can also:
- Review dependencies between your Oracle DB and your code.
- Analyze the impact of changing your Schema, for example changing a table definition or adding an index.
- Estimate code complexity and development efforts.
- Find out which tables are never updated, deleted from multiple places, etc.
- Make sure every process has at least one input (R) and one output (CUD).
Learn how to generate a CRUD matrix using Visual Expert with just a few clicks, showing which Oracle Objects access your data, and how. For example, which Procedures Create/Read/Update/Delete which Tables.
You can also:
- Review dependencies between your Oracle DB and your code.
- Analyze the impact of changing your Schema, for example changing a table definition or adding an index.
- Estimate code complexity and development efforts.
- Find out which tables are never updated, deleted from multiple places, etc.
- Make sure every process has at least one input (R) and one output (CUD).