When analyzing a query that selects from multiple tables, only the first table on the list is shown in the CRUD matrix report, instead of all of them.
WORKAROUND:
None
STATUS:
Waiting for fix to be included in a future version of Toad for Oracle.
Here are steps to replicate:
1) Run the following query CodeXpert.
CREATE OR REPLACE PROCEDURE junk
IS
variable1 NUMBER DEFAULT 0 ;
BEGIN
SELECT COUNT( * )
INTO variable1
FROM user1.table1 Cm,
user1.table2 Clt,
user1.table3 Cmsd,
user2.table4 Cmst
WHERE D_person_id = Cm.Person_id
AND Cm.Com_letter_template_id = Clt.Com_letter_template_id
AND Cm.Com_mailing_id = Cmsd.Com_mailing_id
AND Cmsd.Com_mailing_status_type_id = Cmst.ID
AND Cmst.Code != '06';
END junk;
/
2) Select the Reports tab.
3) Select the CRUD Matrix tab.
4) Scroll down in the CRUD Matrix window and you will see that only table1 is listed in the graph and table for the report.
