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.
- Selecting Refresh Column List button will update any new list information.
- Selecting Print Column List button will print the column list.
- Selecting Add Column button will bring up the Add Column Dialog that allows you to add a new column to the table.
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.
- Selecting Refresh Index List button will update any new index list information.
- Selecting Print Index List button will print the index list.
- Selecting Create New Index button will create an index for the table without needing the exact SQL syntax. The index creator supports DBMS vendor-specific features such as bitmap indexes for Oracle and Fill Factor for Sybase and MS SQL Server.
- Selecting Drop Selected Index button will drop the index.
- Selecting Show / Hide Index Columns allows you to either show or hide the columns comprising the indexes.
Figure - Table Indexes
In the below screen, EMP - Data, the Data tab is selected. Action Buttons include:
- Execute Query button [ctrl-enter]. See Execute Query for more information.
- Stop Query button. See Stop Query for more information.
- Print Table button. See Print Table for more information.
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.
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:
SELECT * FROM EMP WHERE DEPT_ID = 20 AND AGE > 25
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.
- Selecting Refresh Reference Graph button will refresh the displayed graph.
- Selecting Print Reference Graph button will print the graph.
- Selecting Zoom In allows you to zoom in on specific data.
- Selecting Zoom Out allow you to zoom out to less specific detail.
- Select either Exported Keys or Imported Keys.
- Edge Label pull-down menu allows for none, columns, or constraints.
Figure - Reference Tab - Graph
In the below screen, Reference Tab - List, the References tab is selected displaying list data pertinent to the table EMP.
- Selecting Refresh Reference List button will refresh the displayed list.
- Selecting Print Reference List button will print the list.
- Select either Exported Keys or Imported Keys.
Figure - Reference Tab - List
In the below screen, Constraints Tab, the Constraints tab is selected displaying data pertinent to the table EMP.
- Selecting Refresh Constraint List button will refresh the list of constraints.
- Selecting Print Constraints List button will print the constraint list.
Figure - Constraints Tab
