Chapter 2. Screen Layout

Table of Contents

2.1. Initial Screen

2.2. Details of Each Panel of the Screen

2.2.1. Menu
2.2.2. Tool bar
2.2.3. Title bar
2.2.4. Perspective
2.2.5. Schema Tree Browser
2.2.6. Editor
2.2.7. Schema Object Detail
2.2.8. View

This chapter describes the screen layout of tbAdmin.

2.1. Initial Screen

When a user executes tbAdmin and accesses a database server, the following initial screen will appear.

[Figure 2.1] Initial Screen

The initial screen is composed of the following eight sections.

Panel	Description
① Menu	All the menu options that are available in tbAdmin.
② Tool bar	An array of icons for quick and easy access to some menu options.
③ Title bar	The function currently in use and the information of login and access.
④ Perspective	Displays the currently activated perspective. The perspective can be changed to another one.
⑤ Schema Tree Browse	Displays the schema object information of the database, that is connected to tbAdmin as a tree structure.
⑥ SQL Editor	Allows users to edit SQL or PSM. Has view functions such as Browser, Monitor, etc.
⑦ Schema Object Details	Displays detailed information of the schema object, that is selected in Schema Tree Browser.
⑧ DBMS Output	Displays the data from the editor panel in detail.

2.2. Details of Each Panel of the Screen

This section describes the components shown in each area of the screen.

2.2.1. Menu

The menu has the following 8 components.

[Figure 2.2] Menu

File

This component provides access to the database server and allows importing, saving, and printing of profiles.

Menu	Description
New Connection	Accesses a new connection.
End Connection	Disconnects the existing connection.
End All Connection	Disconnects all connections.
Change Password	Changes the password of the currently connected user.
Session Information	Displays information about the currently connected session.
Commit	Permanently applies the result of executing DMLs to all tabs in data.
Rollback	Cancels the result of executing DMLs of all tabs.
Open File	Opens a saved SQL file in the SQL Editor.
Save	Saves the content of the currently open SQL Editor.
Save as	Saves the content of the currently open SQL Editor under a different name.
Save All	Saves all the open SQL Editors.
Close All Tab	Closes all the open tabs.
Print	Executes the printer dialog box.
Exit	Exits tbAdmin.

Edit

This component allows editing SQL statements used in the editor.

Menu	Description
Undo	Cancels an incorrect edit.
Redo	Redoes a canceled edit or execution.
Cut	Cuts all the selected text and copies it to the clipboard.
Copy	Copies all the selected texts to the clipboard.
Paste	Pastes the copied texts in the clipboard to the editor.
Delete	Deletes a character on the cursor or deletes all the characters in the selected area.
Select All	Selects all the characters in the editor.
Find/Replace...	Finds a specific character in the editor.
Comment	Comments out all the lines in the selected area.
Uncomment	Cancels all the comments in the lines in the selected area.
Lower Case	Changes all the letters in the selected area to lower-case letters.
Upper Case	Changes all the letters in the selected area to upper-case letters.
Capitalize	Changes the first letter of each word in the selected area to an upper-case letter, and the other letters in the area to lower-case.
Sentensize	Changes the first letter of each sentence in the selected area to an upper-case letter and the other letters in the area to lower-case.
Invert the Case	Changes all the upper-case letters in the selected area to lower-case, and vice versa.

Action

This component allows users to execute SQL statements.

Menu	Description
Run SQL	Executes (a) selected SQL statement(s).
Run All From Cursor	Executes SQL statements from the current cursor to the last cursor.
Run Step	Executes SQL statements one by one from the current cursor.
Run current SQL	Executes the SQL statement on the current cursor.
Run SQL From All Tab	Executes all SQL statements in all the tabs.
Run And Edit	Changes the mode of the result window to editable mode, so that data can be edited more easily.
Plan	Displays the execution plan of the selected SQL statement.
Current Plan	Displays the execution plan of the current SQL statement.
Template	Calls DML or DDL formats needed for SQL statements, or PL/SQL grammars, syntax, or functions and then displays them on SQL Editor.
SQL History	Displays executed SQLhistory.
Commit	Applies the results of DML execution, permanently.
Rollback	Cancels the results of DML, that have been executed so far.
Change tab title	Changes the name of the currently selected tab.
Format	Makes irregular and difficult SQL statements more readable.
Format all	Makes all the irregular and difficult SQL statements more readable.
Copy to clipboard	Converts SQL statements to a Visual Basic, C/C++, PowerBuilder, Delphi, Java, or Perl code. Copy as Visual Basic Code Copy as C/C++ Code Copy as PowerBuilder Code Copy as Delphi Code Copy as Java Code Copy as Perl Code
Bookmark	When an SQL statement is very long, or when creating various SQL statements such as inline view and sub-query, this bookmark positions the cursor to a desired line, or moves the cursor to a desired position. Bookmarks: Select a line from SQL Editor, and press Ctrl + [0 ~ 9] or save the bookmark information by using the [ Action ] -> [ Bookmark] -> [ Bookmarks] -> [ BookMark 0 ~ 9 ] menus. Go to Bookmark: In order to move to the specified bookmark, press Alt+ [0 ~ 9] or select the [ Action ] -> [ Bookmark] -> [Go to Bookmark] ->[ BookMark 0 ~ 9 ] menus.
Clear output window	Initializes previous DBMS output messages.
Append query result	Logs SQL execution results and displays them on an independent screen.
Maximize SQL	Maximizes the editing screen at the upper part of the SQL Editor.
Maximize Result	Maximizes the result screen at the lower part of the SQL Editor.
Split Pane Evenly	Splits the SQL Editor screen into an SQL editing screen in the upper part and a detailed result screen in the lower part.
Copy to New Tab	Copies the current SQL Editor to a new tab.
Go to Next Tab	When there are multiple SQL Editor tabs, this menu allows users to move the focus to the next tab.
Go to Previous Tab	When there are multiple SQL Editor tabs, this menu allows users to move the focus to the previous tab.
Run Script File..	Executes the SQL statements in the selected file.
Save as Named Script..	Executes Save as Named Script to save frequently used scripts.
Recall Named Script..	Executes Recall Named Script to open frequently used scripts.

Database

This component provides the basic functions of tbAdmin.

Menu	Description
SQL Editor	Provides functions for the execution of multiple SQL statements: batch execution, sequential execution, execution from the current position, selected execution, and execution from all tabs. Displays execution results as DBMS OUTPUT.
PSM Editor	Provides PL/SQL creation, compilation, and execution for packages, functions, and procedures.
Schema Browser	Provides all the schema information of users.
Schema Tree Browser	Provides all the schema information of users, in a tree structure.

DBA

This component provides the basic functions of tbAdmin.

Menu	Description
Session Manager	Monitors session information.
SQL Monitor	Provides statistical SQL information about shared pools, that is set by a variety of standard values.
Transaction Monitor	Provides information about the sessions, processes, and rollback segments of a transaction.
Analyze Manager	Provides analysis of tables or indexes.
Graph and Report	Collects information about system resources to be exported as a chart or report.
Parameter Manager	Provides parameter information and allows users to edit it.
Extents Viewer	Provides information about extents.
Database Information	Provides information about DBMS instances.
Tablespace Manager	Provides information about tablespaces.
Instance Monitor	Provides the instance monitoring function.
Compile Invalid Objects	Allows compilation of invalid objects.
Security Manager	Allows creation, modification, and deletion of permissions.

Tool

Allows exporting of stored data or importing of external data into the database. ASCII characters can also be entered by using the menus below.

Menu	Description
Export	Exports data from the database to an external file.
Import	Imports an external file into the database.
Explmp	The exporting and importing function.
ASCII Table	Displays a table of characters corresponding to ASCII code values.

Window

This component allows the execution of the preferences dialog, where the environment variables can be specified.

Menu	Description
Preferences	Specifies environment variables for tbAdmin.

Help

This component provides the version information and shortcut keys for tbAdmin.

Menu	Description
About tbAdmin	Displays the help and version information of tbAdmin.
Key Assist...	Displays shortcut keys.

2.2.2. Tool bar

For easy and fast execution of frequently used menus, some of the menus are displayed as an icon in the tool bar. The followings list describes the behavior for each icon.

Icon	Description
	Executes the [New Connection] menu under [File].
	Executes the [End Connection] menu under [File].
	Executes the [End All Connection] menu under [File].
	Executes the [Print] menu under [File].
	Executes the [Commit] menu under [File].
	Executes the [Rollback] menu under [File].
	Executes the [Open File...] menu under [File].
	Executes the [Save] menu under [File].
	Executes the [Save as...] menu under [File].
	Executes the [SQL Editor] menu under [Database].
	Executes the [PSM Editor] menu under [Database].
	Executes the [Schema Browser] menu under [Database].
	Executes the [Schema Tree Browser] menu under [Database].
	Executes the [Session Manager] menu under [Database].
	Executes the [SQL Monitor] menu under [Database].
	Executes the [Transaction Monitor] menu under [Database].
	Executes the [Graph and Report] menu under [Database].
	Executes the [Analyze Manager] menu under [Database].
	Executes the [Parameter Manager] menu under [Database].
	Executes the [Extents Viewer] menu under [Database].
	Executes the [Database Information] menu under [Database].
	Executes the [Tablespace Manager] menu under [Database].
	Executes the [Instance Monitor] menu under [Database].
	Executes the [Export] menu under [Tool].
	Executes the [Import] menu under [Tool].
	Executes the [Explmp] menu under [Tool].

Note

Refer to “2.2.1. Menu” for detailed information of each menu.

2.2.3. Title bar

This area displays the information about the currently used functions, logins, and accesses. The title bar will be displayed as follows.

tbAdmin-{The function currently in use}[Login and Access Information]

The following shows an example of the title bar.

2.2.4. Perspective

The currently activated perspective, either Developer Perspective or DBA Perspective, is displayed, and can be changed to the other.

To change the perspective, click the icon or press [>>].

The perspectives that tbAdmin

Developer Perspective

Provides the editors and views required by database developers.
DBA Perspective

Provides the editors and views required by DBAs.

2.2.5. Schema Tree Browser

The information about schema objects of the database is displayed in a tree structure.

2.2.6. Editor

The editors that tbAdmin provides are:

SQL Editor
PSM Editor
Schema Browser
Session Manager
SQL Monitor
Transaction Monitor
Parameter Manager
Extents Viewer
Database Information
Tablespace Manager
Instance Monitor

2.2.7. Schema Object Detail

When a schema object is selected in Schema Tree Browser, the details of the selected schema object will be displayed.

2.2.8. View

This component displays the data from the editor section in detail.

Prev		Next
Chapter 1. Introduction to tbAdmin	Home	Chapter 3. Basic Functions