Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
The enhancements made in the detailed extraction of oracle dependencies need to be carried over to the oracle dependencies node. Example, if you have table_01 and table_02, where table_01 has a foreign key constraint on a column in table_02. This should show table_01 dependent on table_02 through the foreign key constraint.
Example:
CREATE TABLE C##DB_LEFTT.TABLE_01 (A NUMBER(15,5) NOT NULL, B NUMBER(15,5) NOT NULL, C NUMBER(15,5) NOT NULL, D VARCHAR2(25 CHAR) NULL, CONSTRAINT PKEY PRIMARY KEY(A)) GO CREATE TABLE C##DB_LEFTT.TABLE_02 (A NUMBER(15,5) NOT NULL, B VARCHAR2(25 CHAR) NULL, CONSTRAINT PKEY2 PRIMARY KEY(A)) GO ALTER TABLE C##DB_LEFTT.TABLE_02 ADD (CONSTRAINT UKEY2 UNIQUE (B)) GO ALTER TABLE C##DB_LEFTT.TABLE_01 ADD (CONSTRAINT FKEY01 FOREIGN KEY(B) REFERENCES C##DB_LEFTT.TABLE_02(A)) GO
In this example, table TABLE_01 is dependent on TABLE_02 through the foreign key constraint and should show TABLE_02 in the dependencies node of TABLE_01
Extraction enhanced for oracle 9i and above to include the foreign key dependent table. Committed revision: 53486
Extraction enhanced for oracle 9i and above to include the foreign key dependent table. Committed revision: 53486
Verified in ADS v18.0.2-8 for all versions and works fine
Verified in ADS v18.0.2-8 for all versions and works fine
Issue #15066 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.2-8 |
| No time estimate |
Example:
In this example, table TABLE_01 is dependent on TABLE_02 through the foreign key constraint and should show TABLE_02 in the dependencies node of TABLE_01