× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2017-06-23T06:41:52Z  · tomconrad last modified 2018-03-09T22:53:15Z

Can we provide "Dependencies" folder for schema object View in Oracle db.


PM
Priority Low
Complexity Unknown
Component DB - Oracle
Version Future
Product: Aqua Data Studio
Version: 19.0.0-alpha-57
Build #: 54842
Build Date: 2017-Jun-22 04:21:54 PM
 
Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / IN / Oracle Corporation 1.8.0_73-b02
Memory: Max=704,643,072;  Total=425,721,856;  Free=245,089,112;  CPUs=8
 
//Create Table 
CREATE TABLE T1
(
C1  DATE NOT NULL
)
GO
 
//Create View 
CREATE VIEW view_1 AS
SELECT * FROM T1
GO
 
Now,
Go to ADS Tree node,select node View.
Select View "view_1" from the node,expand it.
 
 
Actual Result :
 

It is observed that Dependencies folder is not supported for object Views.

Please refer to the screenshot :15342_Oracle_v19.png

If we compare it with other database like Postgres,SQL Server, we support & display dependencies folder for object Views.

Please refer to the screenshot :PostgreSQL.png

Is this an expected behavior for Oracle? if not then  can we provide support for Dependencies folder for object Views

Can we enchance the schema tree node by adding a "Referenced By" folder for schema objects Views under the dependency node so that users could quickly access this information without having to open the object properties windows.

ADS Matrix :

Oracle db
  oracle 12.1 Oracle11g Oracle10g
ADSv19 Y Y Y
ADSv18 Y Y Y
ADSv17 Y Y Y

 

3 attachments

Issue #15342

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017