Jul
19
Written by:
Ben Boise
7/19/2010
One of the things I love about visiting customers is that I usually end up learning something as a result of the interaction. Just this week, I was on-site with a customer and learned about a neat feature of Toad for Oracle 10.x’s new data grid component. Apparently, you can view parent table data from a child record. This was news to me.
Before we jump right in, let’s take a look at a simple Parent-Child table relationship:
In the above screenshot, OW_CUSTOMERS is the parent table and OW_ORDERS is the child table. OW_ORDERS has a foreign key constraint on the CUST_ID column, which references the CUST_ID column in its parent table, OW_CUSTOMERS. Using the Schema Browser, I’ll view the data in OW_ORDERS:
If I click into the CUST_ID column, I’ll see an ellipsis become visible:
Clicking on the ellipsis opens a pop-up window that displays the data contained in the parent table (OW_CUSTOMERS in our example):
I didn’t know this feature existed until the customer told me about it. As much as I know about Toad for Oracle, it seems that I’m constantly reminded that I still have much to learn. Hopefully, this is new and helpful to you!
2 comment(s) so far...
Re: Viewing Parent data from a child record using Toad for Oracle
'Enable value lookup for foreign key constraints' must be turned on in the options View > Options > Schema Browser > Data Tab
Great feature, but one that I frequently overlook as there's just so much to know/show!
By hillbillyToad on
7/19/2010
|
Re: Viewing Parent data from a child record using Toad for Oracle
Ah, thank you for clarifying the settings necessary for this to work!
By BBoise on
7/19/2010
|