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.
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).
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.
Already in a trial? Talk to sales or buy now online.
Already a loyal fan of Toad for Oracle? Renew now.
Head over to the Toad for Oracle forum on Toad World®! Chat with the Toad developers, and lots of experienced users.
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
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: