Specific Data Functions

You can search and replace text in a data set (Table or SQL query result). The functionality also covers Memo, CLOB and text compatible BLOB columns.

It is also possible to search and replace code in SQL windows and schema files. And some interface parts of the application are searchable too.

BLOB and CLOB fields allow to store different kinds of binary and text data like graphics, large text, database reports etc. Blob Editor is a tool to work with such data.

There is a possibility to search text not only in the table data, but in the database metadata too. For example, you may need to find a table by its field name or a stored procedure by its code fragment. In high-level databases, you have dozens of database object types like views, triggers, sequences, database links, jobs, etc., and Database Tour allows to find them by their text or descriptions.

Some server databases like Oracle, SQL Server, PostgreSQL, MySQL allow you describe the tables and their columns right in the database. Those descriptions can be used for documenting your systems and working environment. Database Tour facilitates working with table and column description by providing a unified and easy-to-use interface.

The descriptions from database can be exported to a number of common formats like Excel or HTML, and thus easily embedded in your company documentation, for example.

You can use several useful functions for selected fields of a dataset: trimming, changing case of symbols etc.