DB Solo
Back to Index

Database Object Browser

DB Solo's browser window displays all configured servers, databases, their tables, and the associated table data. You can also view, create, and drop the following object types: databases, tables, indexes, sequences, synonyms, defaults, rules, user-defined data types, tablespaces, filegroups, and many other types as well.

Within the browser window, table data can be:

The Browser Window, displayed below, has a server connection to an Oracle database while the associated tables are expanded.

Figure - Browser Window

When a table is selected on the left hand side of the browser, as shown below with EMP, six tabs: Columns, Indexes, Data, References, Constraints and Triggers are displayed on the right.

In the below screen, EMP - Columns, the tab, Columns, is selected with Name, Data Type, Nullable, Length, and Digits columns displaying data pertinent to the table, EMP.

Figure - Table Columns

In the below screen, EMP - Indexes, the Indexes tab is selected with Table Name, Index Name, and Unique columns displaying data pertinent to the table EMP.

Figure - Table Indexes

In the below screen, EMP - Data, the Data tab is selected. Action Buttons include:

Note: You can view statistics on selected cells in result set windows. Below screen illustrates multiple numeric cells selected and the statistics MIN, MAX, SUM, and AVG. are displayed in the bottom half of the screen.

Figure - Table Data

Execute Query

Select the Execute Query button, within the Data tab, to run a query and retrieve data form the database.

Use Search Results field to find data and narrow the display.

Stop Query

Select the Stop Query button to stop an active query. Button will display red and will be functional while a query is active.

Insert New Row

Select the Insert New Row button, within the Data tab, to insert data into the table.

The Insert New Row screen is shown below.

Figure - Inserting New Row

1. Choose values for the columns of the new row you want to create. If the data type of the column is either a blob or clob, you can enter the value either manually in the provided text area or load the value from an operating system file. If you wish to enter a null value in the column, check the Set to NULL check box.
2. Choose Insert to insert the new table row into the table or Cancel to cancel out of the operation.

Delete Selected Row

Select Delete Selected Row button, within the Data tab, to delete the table row from the table. Delete Row message will display prior to deletion.

Figure - Deleting A Row

Export Table Data

1. Select Export Table Data button, within the Data tab, to export table data from the database to either a clipboard and or a file for further analysis. The entire table can be exported or just the selection within the results grid. See Export Data screen shown below.

Figure - Export Data

2. The destination can be selected to be either the system clipboard or an OS file. If 'File' is selected, you can select the file encoding that will be used when the file is written out. Common encoding types are UTF-8, windows-1252, US-ASCII, Big5, EUC-JP and EUC-KR.
3. If File is chosen, Destination File must be specified. Browse to the chosen file.
4. Choose a Column Separator character and a Record Separator character. Select radio button for adding a Header Row in the format.
5. Choose a Number Format if the selection is an integer. This interface provides for formatting and parsing numbers.
6. If the selection is String Format, choose the correct radio button. If yes is selected, a quote character must be configured.
7. Choosing Next will provide a preview screen of the Export Data Preview, as shown below:

Figure - Export Data Preview

8. If you select Export, a message will be displayed with the results as shown below. Otherwise Back will send you back to the Export Data screen and Cancel will end the export operation.

Figure - Data successfully exported

Print Table

Prints the table data.

Defining Table Filters

1. Select Define Table Filter button, within the Data tab, to filter the table data. Defining a table filter allows you to create a `where' statement that DB Solo will use when fetching table data from your database server. If your table contains thousands of rows, it is important that you define a filter before you retrieve all rows from the table. This will lead to a faster response time and reduced memory usage by DB Solo since it will only retrieve a small portion of all the data rows (assuming your filter is set up correctly).

Figure - Define Filter

2. Choose a column to filter on. The column combo box will contain all columns of the current table.
3. Choose a operand. For example, if you wish to select a certain employee from the EMP table, you would select the = (equals) operand. The operand combo box has all the potential operands you can use in your filter:
4. Choose a value you want to use in your filter. For example, if you wish to select a certain employee from the EMP table, you would enter the employee id of the person.
5. You may combine multiple filters in your `where' statement by clicking on the `AND' or `OR' button. For example, if you wanted to perform the following select statement:


You would first create a filter for DEPT_ID = 20 and then click on `AND' select the other filter from the tree and set it to AGE > 25.

6. Choose Use Filter to configure the filter or No Filter if you don't want to use a filter at all. If there is no filter defined, DB Solo will retrieve all rows in the table from your database server.

Table References

If your table contains a foreign-key reference to another table, or if some other table contains a foreign-key reference to the selected table, you can view these relationships graphically as well as a list, under the References tab.

In the below screen, Reference Tab - Graph, the References tab is selected displaying graph data pertinent to the table help_topic.

Figure - Reference Tab - Graph

In the below screen, Reference Tab - List, the References tab is selected displaying list data pertinent to the table EMP.

Figure - Reference Tab - List

In the below screen, Constraints Tab, the Constraints tab is selected displaying data pertinent to the table EMP.

Figure - Constraints Tab

Back to Index DB Solo