Databrid A browsing, retrieval and manipulation tool for Oracle Databases.
Download

Databrid Ranking & Summary

Databrid Tags

browse SQL manipulation oracle database database browser manipulate databases

Databrid Description

A browsing, retrieval and manipulation tool for Oracle Databases. Databrid is a tool designed for 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 EditorThe 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.BrowserThe 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.FileThe 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.JobsThis 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. Here are some key features of "Databrid": Sql Editor: · Autocompletion of table column names. · Highlighting of words the same as the one currently under the cursor. · Context Sensitive SQL and PLSQL editors. · Automatic Case adjustment for keywords and functions (optional). · Edit SQL and PLSQL files. · Commit and Roll back database changes. · Build and execute Select statements in the editor and perform the following: View the output in a user friendly table. Save the output as a CSV (comma delimited file) or insert statements. Output can be sent to the clipboard or to a file. Count the number of records. · Tune the Select Statement. · Develop SQL and PLSQL statements. Oracle DBMS_OUTPUT output is captured into a separate area. · Create, modify and delete database objects. Schema Browser: · Browse database objects for multiple users. · Produce creation scripts for database objects. · Allows you to see information regarding database objects. File: · SQL and PLSQL files can be edited with syntax highlighting and an optional automatic case adjustment for keywords and functions. Autocompletion of columns names is also available. · The ability to use SQL statements to add additional information to CSV (delimited) files while binding in values from the CSV. · The ability to manipulate the database using use information from a CSV file. Requirements: · Java 1.4 or later. What's New in This Release: · Released to fix small bugs with commit, rollback not initially showing, Save As not setting tab name, multi-row table copy not working properly and count records not always working.

Databrid Related Software