Toad World Blog

Getting to Know the Toad for Oracle Schema Browser

Feb 5, 2018 10:15:00 AM by Clarisa Maman Orfali

The Schema Browser is an interface that allows us to work with various objects in the database.

To learn about this interface, we first open Toad and connect to a database schema.

For this example, we are using the SCOTT schema of Oracle Express Edition database.

The first thing we see when we connect to the database is the Editor. For more information about this feature, you can read an article HERE and view the video HERE (Spanish language).

To access the "Schema Browser", choose the second icon in the icon bar or select “Schema Browser” from the "Database" menu.

In this screenshot, we can see the connection schema and all the objects that belong to it.

When selecting "Tables", we can see a list of tables that belong to the schema. If we were to have hundreds of tables in our schema, the box below that functions as a filter, would allow us to search them by name.

To the right of the "Schema Selection", we can see the icon bar of the Schema Browser window, which allows us to perform the following actions:

-          Change Session

-          Back to Table DATABASE_SCHEMA.TABLE (Alt + Left)

-          Forward (Alt + Right)

-          Refresh All objects

-          Refresh current list (left side of browser)

-          Refresh the detail panel (right side of browser)

-          Clear all datagrid filters

-          Schema Browser Icon Legend

-          Browser Style

Since the first actions are very easy to understand. We will go into more detail about the last icon on this icon bar, the "Browser Style", which allows us to modify the display style of the “Schema Browser”.

The objects are displayed by default as Dropdown, but we can also see them as Tabbed (multi-line tabs).

Tabbed (single row of tabs) is a form of visualization where we can see the previous and next scroll buttons.

 

Another form of visualization is Treeview, as demonstrated below:

Additionally, we can indicate if we want to visualize the icons that are under the filter box by selecting or deselecting the "Show LHS Toolbars" option. Similarly, we can show or hide the icons of the list of objects by selecting or unselecting the option "Show LHS Tab/Dropdown Images".

If the items have assigned icons, we can also show or hide them by selecting or deselecting the "Show Item Images" option.

On the other hand, we have the option to configure which objects we want to see in the list of schema objects by selecting the option "Configure LHS Object Types".

This option allows us to select which types of objects we want to visualize. For example, we deselect the "DB Links" option in the window:

 

When we expand the list of objects, we can see that the DB Links option is no longer displayed (figure on the right).

8176.c12.jpg-1100x19998

 

List of Favorites

We have the option to add items to a list of favorites where we can have the objects that we use most as a shortcut.

To do this, we select the object we want to add to the list of favorites, choose the EMP table with a right click on the mouse, and select "Add to SB Favorites List". A window will open where we will create a folder that we’ll name, for example, Demo, and then click on the OK button.

 

In order to see all the objects that we have in our favorites list, we need to choose the visualization form of Treeview, which we saw earlier in this post, by selecting Browser Style > Treeview. Then, we select the "Show Favorites" box. In this way, all folders with objects added to our favorites list will be displayed.

Finally, every time we select an object in the Dropdown view, Toad for Oracle will activate or deactivate the icons on the toolbar that allow the objects to perform the operations that the user has access to depending on the type of user that it is connected to.

In future articles we will increase the utilization of this window for the editing of different database objects as well as the use of various assistants provided by Toad for Oracle.

 

Try Toad free for 30 days. 

Free 30-day Trial

Already in a trial? Talk to sales or buy now online.

Already a loyal fan of Toad for Oracle? Renew now.

 

Related information

Video: Toad for Oracle - Compare DB environments with multiple schemas

Blog: How to compare two schemas in Oracle using Toad®

Blog: Compare and Sync Multiple Tables with Toad

More blogs from Clarissa

 

Have questions, comments or an idea for a new Toad feature?

Head over to the Toad for Oracle forum on Toad World®!  Chat with the Toad developers, and lots of experienced users. 

 

Help your colleagues

If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!

Tags: Toad for Oracle

Clarisa Maman Orfali

Written by Clarisa Maman Orfali

Clarisa is a System Engineer with more than 24 years of experience as a developer, teacher, and consultant in Information Technology. She was a Founder and CEO between 2013 to 2020 at ClarTech Solutions, Inc., a consulting firm specializing in Oracle APEX and Open Source technologies. Clarisa entered the world of Oracle technologies in 2009. After a few years, she discovered the power of application development with Oracle Application Express (APEX) and specialized in that area.

Clarisa is from Argentina, and she is living and working in Irvine, California, in the United States. She's also a Co-Founder of the Argentina Oracle User Group (AROUG). In addition, she had actively participated in large and popular events such as the OTN Tour Argentina and Oracle APEX Tour Latin America after called Oracle Developer Tour. She's also authored the first three Spanish books about Oracle Application Express and recorded and published several Online Video Courses.

She has a great passion for Oracle technologies and wants to expand that passion and influence, transferring her knowledge and experience to the entire Latin American and worldwide Oracle communities. You can always contact her through her Twitter account (@Clari707).

Clarisa loves spending time with her family by enjoying outdoor activities with her two adored children, Melanie and Nicolas, as well as hanging out with her friends. Also, she loves traveling with her husband Julio worldwide and to takes new challenges at every moment of her life.