Databrid

Have you been searching for a tool that would help you to access and manipulate the data in your databases? Then you might like to try the Databrid 1.4 that has the features for data access and manipulation within Oracle or MySQL database. The software is best to be used by the DBA, Developers, Analyst, etc using Oracle database as it comprises of the features that help in increasing the productivity. You can perform browsing, manipulation and retrieval of data with minimum effort. It functions on the basis of the tabbed areas in the Databrid application. In addition it supports you with an SQL Editor, File, Browser, and Jobs features.

Databrid 1.4 on launch shows you a log-in screen. You need to fill in the features relating to Connect To, Connection, Connection Buttons and Connection Attributes. With the SQL Editor you need to open a file and commit all the changes to the database. Copy the selected text field or table to the clipboard and paste it where required. Make the required changes to the information in the database and view the SQL statements that have successfully run. With the Browser you can have a glance at the various parts of database schema. Have the view of the tables, data, types, indexes, procedures, etc. The File feature helps to you to work with the CSV file without loading it into the database. It has the two main features that are ‘CSV Update’ and ‘Database Update’. The Job option allows you to view the active and inactive jobs that have been running in the background. With these many features having different sub features you can make various modification as required by you.

Databrid 1.4 allows you to work efficiently with the database and make the modification to its various aspects. Rating point of 4.5 has been assigned to the software for its powerful data manipulation features, highly useful SQl editor and the sheer convenience that this utility provides.

Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on MySql and 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 sql autocompletion, word and 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 are currently running or have finished. Jobs that are running can also be stopped.