Projects tagged ‘dba’ and ‘sql’

A powerful MySQL client for Win32.

Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and ... [More] MySQL) and can be extended to include specialized support for other databases. The project started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of SQuirreL SQL. [Less]

Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!!!), table browser, field browser, TOP ... [More] records, most used tables, CSV results export, etc. [Less]

COMING SOON.... AnyDBA will be a library of SQL scripts for Oracle & MySQL DBAs. AnyDBA will provide easy database monitoring and troubleshooting scripts which can manage many databases from ... [More] one place. The scripts are developed in pure SQL using SQL*Plus / mysql command line tools. [Less]

Tools for dba.

sp_wcProject is a stored procedure designed to allow you to easily define the projection of columns used in a table, view, or table valued function and then optionally run the query. The column names ... [More] may be specified using wildcards, hence the "wc" name prefix. [Less]

a plsql utility for easily determining table sizes. The data returned includes table data size, index size, and lob size. Each value is returned individually, and also summed to provide a total ... [More] table size. Figured are reported in MB and GB. To run, first create the types and then the package. This currently works for the current user, I'm going to modify it to accept a schema as input and point the references to all_tables/all_segments/all_indexes/all_lobs instead of the user views. to execute, run select from table(table_info_pkg.table_info(table_name)); where table_name is a string. example: select from table(table_info_pkg.table_info('CLAIMS')); [Less]

This is a new intiative to develop a unique Dashboarding application. The development will be in PHP. The studio will allow to connect to any database and Excel files. It will allow you to create ... [More] reports and Dashboards. Dashboard Studio will be able to import dashboard definitions directly from InfoCaptor Designer. It will also have in-built role and security mechanism. This will be a totally new application from InfoCaptor which is a java based Dashboard application. [Less]

Create 10 000 sql insert queries in minutes for any table. Posibilities Export\import project Fild values generator All you need to do is configure your fields and how they will be filled ... [More] , and then pres Generate SQL. Do not forget to export project for future use. [Less]

Report Oracle Database Info