|
Databrid is a browsing, retrieval and manipulation tool designed for the
novice to the expert user. Databrid works on an Oracle Database (versions 8 and above
although not all functionality in the Browser is available for the lower
versions). The core functionality of Databrid revolves around the tabbed
areas within the Databrid application. The four main tabs in the main screen of
Databrid are: SQL Editor, Browser, File and Jobs.
SQL Editor
----------
The SQL Editor tab allows you to write and run SQL and PLSQL. The tab provides the
ability to use one of more syntax highlighting editors with automatic case adjustment
for keywords. Provided with each editor is a table for displaying SQL query results
and a text output area to display DBMS_Output output. Jobs can be run in the background
allowing for the execution of multiple statements at any given time.
Browser
-------
The Browser tab allows the you to browse various parts of the database schema. The
browsing is done via a particular schema user and displays information on tables, views,
sequences etc. Features include the generation of database creation statements for tables,
views etc, browsing table or view data, truncating tables, etc.
File
----
The File tab allows you work with a CSV (comma delimited text file) and the database
without having to load the CSV into the database. This tab has two areas that functionality:
CSV Update and Database Update. CSV Update allows you to add additional columns to a CSV
using a Select statement, including binding CSV column values to the Select statement.
Database Update allows you to update the database using insert, updates, deletes or PLSql by
binding the CSV column values into your statement.
Jobs
----
This tab allows you to view which jobs (started from the SQL Editor and File tabs) are
currently running or have finished. Jobs that are running can also be stopped.
|
