# Schema Browser - Shared DB Llink **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 26, 2018, 12:25pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765 "2018-03-26T12:25:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![david.fimble](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@david.fimble](https://forums.toadworld.com/u/david.fimble)\ **Post date:** [March 26, 2018, 12:25pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/1 "2018-03-26T12:25:35Z")
In the schema browser, if I select a DB Link that is “shared”, the grid on the right side shows that it is shared. If I have the right hand view show all of the DB Links the “Shared” attribute is missing from the grid forcing me to select each DB Link one by one to see its properties. Is there a way to show the “shared” attribute when viewing all of the DB Links? Thanks, David ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 26, 2018, 12:34pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/2 "2018-03-26T12:34:22Z")
Sorry, looks like that info isn’t available that way. The only thing that comes to mind is that you could click the Filter icon, check “Custom Filter” and “View/Edit Query Before Executing”, and then click OK. A dialog will appear that contains the query that the SB is about to run to load the left hand side. To limit it to shared links, add: and to\_number(bitand(k.flag, 1)) = 1 To limit it to non-shared links, add: and to\_number(bitand(k.flag, 1)) = 0 ---
**Author:** ![david.fimble](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@david.fimble](https://forums.toadworld.com/u/david.fimble)\ **Post date:** [March 26, 2018, 1:04pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/3 "2018-03-26T13:04:13Z")
Thanks, that works and will allow me to move forward with what I am doing. Would this be something that can be enhanced in the future? Thanks, David **From:** John Dorlon [[mailto:bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)] **Sent:** Monday, March 26, 2018 2:35 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [External Email] RE: [Toad for Oracle - Discussion Forum] Schema Browser - Shared DB Llink # EXTERNAL EMAIL **[RE: Schema Browser - Shared DB Llink](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Fp%2F35178%2F70024%2370024&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7Cd54b072e865f445f713d08d59350b718%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576897239245498&sdata=OlHi44O9d6%2B0IVpz2k29nf0GRvjW8tr08ESc7GSO0YM%3D&reserved=0)** Reply by John Dorlon Sorry, looks like that info isn’t available that way. The only thing that comes to mind is that you could click the Filter icon, check “Custom Filter” and “View/Edit Query Before Executing”, and then click OK. A dialog will appear that contains the query that the SB is about to run to load the left hand side. To limit it to shared links, add: and to\_number(bitand(k.flag, 1)) = 1 To limit it to non-shared links, add: and to\_number(bitand(k.flag, 1)) = 0 To reply, please reply-all to this email. [Stop receiving emails](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Ft%2F35178%3Fsubscribe%3Dfalse&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7Cd54b072e865f445f713d08d59350b718%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576897239245498&sdata=vqJSxNhTIOPGH4KiuAZ3HhwcYAGxgnUBTPGmuHu%2BFN0%3D&reserved=0) on this subject. Or [ Unsubscribe from Toad for Oracle Forum](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%3Fsubscribe%3Dfalse&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7Cd54b072e865f445f713d08d59350b718%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576897239245498&sdata=X3d1%2FM8pGf7MMr4Y5jAx2oIkKprHVMKSRKED3dqQ%2B8k%3D&reserved=0) notifications altogether. Toad for Oracle - Discussion Forum [Flag](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Fp%2F35178%2F70024%3FAbuseContentId%3D2ac6b3bf-5f1e-48e4-8fb3-2296d6c23cb9%26AbuseContentTypeId%3Df586769b-0822-468a-b7f3-a94d480ed9b0%26AbuseFlag%3Dtrue&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7Cd54b072e865f445f713d08d59350b718%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576897239255495&sdata=lxhIX3NHsz9lnmDsWU5D7srpo8V7UgzPZaM3zS%2BSmnE%3D&reserved=0) this post as spam/abuse. * * * \*\*\*\*\* This email is from an external sender outside of the CenterPoint Energy network. Be cautious about clicking links or opening attachments from unknown sources. \*\*\*\*\* * * * ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 26, 2018, 1:06pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/4 "2018-03-26T13:06:22Z")
We are no longer adding features for Toad 13 in preparation for release, but I can add it after that (13.1 beta or whatever it will be) ---
**Author:** ![david.fimble](https://avatars.discourse-cdn.com/v4/letter/d/f475e1/32.png) [@david.fimble](https://forums.toadworld.com/u/david.fimble)\ **Post date:** [March 26, 2018, 1:15pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/5 "2018-03-26T13:15:21Z")
Sounds great. Thanks! **From:** John Dorlon [[mailto:bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)] **Sent:** Monday, March 26, 2018 3:08 PM **To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com) **Subject:** [External Email] RE: [Toad for Oracle - Discussion Forum] Schema Browser - Shared DB Llink # EXTERNAL EMAIL **[RE: Schema Browser - Shared DB Llink](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Fp%2F35178%2F70026%2370026&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7C609e61c162cc4fb9722e08d593555071%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576916995875417&sdata=Yg36sUZrH7B48HOUw1wPJd6hh4IvSFTGgo48q4gCkpc%3D&reserved=0)** Reply by John Dorlon We are no longer adding features for Toad 13 in preparation for release, but I can add it after that (13.1 beta or whatever it will be) To reply, please reply-all to this email. [Stop receiving emails](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Ft%2F35178%3Fsubscribe%3Dfalse&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7C609e61c162cc4fb9722e08d593555071%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576916995875417&sdata=kYwTmOElPHu9alYdDgQOrUHQcLBIVyQg8WIutVxBkIg%3D&reserved=0) on this subject. Or [ Unsubscribe from Toad for Oracle Forum](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%3Fsubscribe%3Dfalse&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7C609e61c162cc4fb9722e08d593555071%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576916995875417&sdata=BLrS6JUBfwHuv68hjzx9Pj9D4h87RF%2BAfu1LnNnnYFM%3D&reserved=0) notifications altogether. Toad for Oracle - Discussion Forum [Flag](https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.toadworld.com%2Fproducts%2Ftoad-for-oracle%2Ff%2F10%2Fp%2F35178%2F70026%3FAbuseContentId%3D55ebc15f-5817-4c02-8142-a96bc10b2463%26AbuseContentTypeId%3Df586769b-0822-468a-b7f3-a94d480ed9b0%26AbuseFlag%3Dtrue&data=02%7C01%7Cdavid.fimble%40centerpointenergy.com%7C609e61c162cc4fb9722e08d593555071%7C88cc5fd7fd7844b6ad75b6915088974f%7C0%7C0%7C636576916995875417&sdata=r508aLBFzc%2FXtmPFAjz0SsCLGjrynW4vLbcs95VYdY0%3D&reserved=0) this post as spam/abuse. * * * \*\*\*\*\* This email is from an external sender outside of the CenterPoint Energy network. Be cautious about clicking links or opening attachments from unknown sources. \*\*\*\*\* * * * ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [June 12, 2018, 3:05pm UTC](https://forums.toadworld.com/t/schema-browser-shared-db-llink/40765/6 "2018-06-12T15:05:46Z")
Done for next beta.