Toad World® Forums

[REQ] - Group for External Tables


#1

Can a new group be created for External Tables in the schema browser. Like the way Materialized Views are displayed.

–DATABASE

+----LOGON SCHEMA

   +------- TABLES

   +------- VIEWS

   +------- EXTERNAL TABLES

   +------- INDEXES

   ...etc.

#2

Hi Rob,

There is a way you can show only External tables now using a filter in the tables tab.

  1. click the filter icon in the LHS toolbar of the tables tab

  2. check “view/edit query before executing”

  3. check “custom filter” and OK

  4. When prompted, change the where clause to show only external tables OK.

  5. Your filter should now be applied, now from the filter dropdown, do a “Save current filter as” and name it

You can now toggle the filter on/off right from the filter dropdown button.


#3

I’ve actually used the filter before and even hacked them to show up in “VIEWS”. We use External Tables “heavily” and it would be a useful feature for us. Just a suggestion.

Rob Steward | IT Software Development Advisor

Enterprise Data Solutions

From: Brad Boddicker [mailto:bounce-Brad_Boddicker@beta.toadworld.com]
Sent: Monday, March 11, 2013 2:43 PM
To: toadoraclebeta@beta.toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] [REQ] - Group for External Tables

Hi Rob,

There is a way you can show only External tables now using a filter in the tables tab.

  1. click the filter icon in the LHS toolbar of the tables tab

  2. check “view/edit query before executing”

  3. check “custom filter” and OK

  4. When prompted, change the where clause to show only external tables OK.

  5. Your filter should now be applied, now from the filter dropdown, do a “Save current filter as” and name it

You can now toggle the filter on/off right from the filter dropdown button.