Like many database, tables are related, and many times you need to look though the tables,
at the dataset(s) for the same specific CustID say in all the Related tables.
And if you have say 10 tables all with the Column "CustID", which is the Foreign Key between them, I was thinking if you where able to use the same Syntax to get prompted to Enter Parameter Values from the Schema Browser - Table Filter, that would save you hours of having to change the Filter on Each Table every time you wanted to view the Data for different Customer.
So the Table Filter would look something like .... using DEPT and EMP,
as the column DEPTNO is on both, the both Filter would read
And when you refresh, click the table and the data is to be selected,
the similar POPup as you get from the SQL window, would allow enter of the Parameter Values.
Maybe this is already existing, but I was unable to find anything in the "Help",
or docs...
would only expect to be able to do simple stuff like
where "column" = :CustID so :CustID is then used else where in the Child table etc...
Heck maybe even share the Parameters Know from the SQL.
Hey Sean,
Sure, I can add that, but the master-detail browser was written exactly for this kind of thing. You can set up whatever complex relationships you want in there, and then browse around and all the details tables are kept in sync. Once you have it set up, I think you'll find it more convenient than what you are proposing, because you won't have to mess around with variables at all. Here's a short video.
You can also set up detail tables from within the schema browser:
True I had forgotten about this,
But it is not always, going to work, as I think this works of the defined "Foreign" keys,
on the tables, So sometimes when have Master(1) --> Child(1)/Master(2) -> Child(2)
and there is a a Direct Relationship be Master(1) and Child(2) But there is no need to have Foreign Key for it... Examples a sequence on Master(1), is actually in all the tables...
So the Master/Child Reporting in this case does not work,
and as it appear you cannot Manually Imply the Connection Between the Tables
So having the "Parameter" Style, option in the Schema Browser Filter helps in these cases.
thanks.
The master detail browser allows you define any relationship. A foreign key does not need to exist.
In the example below, I set it up using the views DBA_TABLES and DBA_TAB_COLUMNS. I manually defined the relationship between them, because they have no foreign key between them.
You can also manually define the relationship in the schema browser (here, you can manually define the relationship by making variables named after columns in the parent dataset). In this case, the child and parent column names match, but this does not have to be the case.
