Toad World Blog

Getting to Know the Toad for Oracle Schema Browser

Feb 5, 2018 11: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.

Tags: Toad for Oracle

Clarisa Maman Orfali

Written by Clarisa Maman Orfali

Clarisa is from Argentina. She is Founder and Director at ClarTech Solutions, Inc. a company dedicated to the development, consultancy and training in Information Technologies located in Southern California in the United States.

She is a Systems Engineer with more than 18 years of experience in systems development. She was introduced in Oracle Technologies in 2009, a few years later she discovered the great power of development with Oracle Application Express (APEX) and has specialized since then in that area.

She is also Co-Founder of the Oracle Users Group of Argentina (AROUG) and founder of Oracle APEX Latin America meetup, has also actively participated in the organization and as Presenter of big and popular events such as the OTN Tour and the Oracle APEX Tour of Latin America. In 2014 was recognized by the Oracle Corporation with the Oracle ACE Award. Then, in March 2018, she was promoted to Oracle ACE Director.

She is also the author of the first three books in Spanish about Oracle APEX:

  • Published in June 30, 2017: "Oracle APEX 5.1" (Spanish Edition). You can get the book in Paperback version.
  • Published in November 5, 2015: "Introducción a Oracle APEX 5.0" (Spanish Edition). You can get the book in Paperback version and Kindle version.
  • Published In January 26, 2016: "Integración Sin Costo de JasperReports en Oracle APEX 5.0" (Spansih Edition). You can get the book in Paperback version and Kindle version.