Oracle SQL Client Tools

DBHawk is a web-based Oracle SQL client and database management software

Oracle SQL Client Tools

It allows Oracle SQL developers, DBAs and SQL BI Users to manage, develop Oracle databases through a web browser. Users do not required to install any Oracle client on their machine. Using DBHawk development managers can give quick access to their developers and business users without relying on DBAs. Also Managers can audit users SQL activities. DBHawk gives total power to product managers with quick and easy access to Oracle databases.

DBHawk Features For Oracle Database

Oracle SQL developers can use visual SQL query builder to drag and drop database tables, build SQL queries, build oracle database ad hoc reports, parameterized reports, online data dashboards, schedule reports-all with point and click simplicity and database security. SQL users can build D3 based charts. It’s a better alternative for Oracle Application Express (APEX) users. Like APEX, it does not require you to build a PL SQL based solution.


Online Oracle Data Browser

DBHawk supports full online Oracle database browsing capabilities. Users can view database table data, filter data, count total number of rows in a table.

Oracle Data Browser

Oracle Data Editor

DBHawk online data editor allows to create, insert, update, and delete data. Users can also update clob, blob data.

Oracle Data Editor

Oracle Export/Import Data

DBHawk online export data feature allows to export table data into csv, html, insert and pdf formats.
Users can also import csv data directly to the tables. DBHawk parse input csv data columns and display column mappings between table columns and uploaded CSV file data columns. After successful import, users can save import as a job and schedule it to run at regular interval.

Oracle Export/Import Data

Online Oracle Column Manager

Using DBHawk, users can view oracle table column details, alter table columns, and add new columns.

Online Oracle Column Manager

Oracle Index Client Tool

Table indexes provides efficient table data search. Using DBHawk, users can view index details including index uniqueness, index type, index columns, index tablespace name, index statistics. Users can also add new with a new index screen and preview SQL prior to creating an index. Users can drop index.
Users can add Non-unique, Unique and Bitmap indexes using DBHawk index creator.

Oracle Index Client Tool

Web-Based Oracle Constraints Manager

Constraints are the rules enforced on data columns on table. Using DBHawk, users can view table constraints details. It displays Constraint name, Type, Constraint status, Constraint columns. By clicking on the constraint name, users can view constraint detailed information such as Last changed, Delete rule, reference owner, reference table, reference columns. User can also add new Primary Key, Foreign key, Unique key and Check constraints for the table. Users can enable/disable constraints, drop constraint with a simple click.

Web-Based Oracle Constraints Manager

Oracle Database Trigger Manager

Oracle triggers are stored procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the database table. Using DBHawk trigger manager, users can view existing table trigger details, View trigger object dependencies, Enable/Disable trigger, drop a trigger. Users can also add new BEFORE or AFTER events triggers for INSERT, UPDATE and DELETE statements.

Oracle Database Trigger Manager

Oracle Object Grants Manager

With granted privilege, user can execute a particular SQL statement with another user’s object. DBHawk provides intuitive Object grants manager. Using DBHawk grant manager for the object, users can select various privileges such as SELECT, INSERT, UPDATE, REFERENCE etc and assign those privileges to other users. DBHawk display current Object’s granted privileges and allow user to revoke those privileges with a simple click.

Oracle Object Grants Manager

Online dependencies & referential viewer

DBHawk displays table references details. Using referential screen, users can find out parent and child tables. DBHawk object dependencies display dependency between objects. Users can quickly figure out dependent objects and depends on objects.

Online dependencies & referential viewer

Oracle Table DDL Generator

DBHawk display table DDL with a simple click. DBHawk runs DBMS_METADATA.GET_DDL(‘TABLE’,’
‘) to get table DDL.

Oracle Table DDL Generator

Oracle Web-based View Manager

Using DBHawk, users can create new Oracle view, rename a view, drop a view, count total rows in a view, modify view, filter view data, view column details.

Oracle Online View Manager

Oracle Sequence Manager

The sequence generator generates sequential numbers, which can help to generate unique primary keys. DBHawk Sequence Manager display all sequence details. Users can Drop sequence, create a new sequence, assign grants, view dependent object details and get ddl for the sequence.

Oracle Sequence Manager

Web-based Oracle Database Link Manager

A database link is a connection between two physical database servers that allows a client to access them as one logical database. DBHawk provides DBLinks management. Users can view DB Link details, test database link, create new database link, drop a link, generate SQL for the existing database link

Web-based Oracle Database Link Manager

Oracle Synonym Manager Online

An Oracle synonym is a pointer to a database object. Synonyms provide data and location independence. With DBHawk, users can manage synonyms. Users can view synonym details, reference object and object type details, view data for table or view synonyms, view SQL details and create new synonyms.

Oracle Synonym Manager Online

Oracle Stored Program Manager

Using DBHawk, users can manage database functions, procedures, triggers, packages, package body, types, type body. User can add new stored programs, modify existing Oracle stored programs.

Oracle Stored Program Manager

Oracle Materialized View Manager

Oracle materialized view is a snapshot of data at single point in time. DBHawk displays materialized view details including SQL query, last refresh time, last refresh type, refresh method, refresh mode etc. Users can browse materialized view data, columns. It also allows to create new materialized view, get DDL.

Oracle Materialized View Manager

Oracle Database Objects Creator

DBHawk makes Oracle database object creation very easy for developers. With DBHawk intuitive UI, Oracle developers can create various database objects such as Database tables, Views, Synonyms, DB Links, Functions, Procedure, Package, Types, Triggers, Sequence and Materialized View.

Oracle Database Objects Creator

Analyzing Oracle Tables, and Indexes with DBHawk

Current statistics for tables and indexes are stored the data dictionary. These statistics can be used by the optimizer to choose the most efficient execution plan for SQL statements accessing analyzed objects. DBHawk provides Analyze table and index utility. It uses DBMS_STATS package and generate statement to analyze database tables and index.

Analyzing Oracle Tables, and Indexes with DBHawk

Oracle Tablespace Manager

Oracle tablespaces are the logical database structures that hold data for an Oracle Database. DBHawk provides Oracle Tablespace monitoring and management. DBA can monitor tablespace usage with graph which shows free and used space. It displays Tablespace status, Content type, Size, Used size, Percent used size and maximum size. DBAs can view and alter tablespace. It shows tablespace detailed information such as datafiles, Object names, Blocks, Object size and maximum extent size. Using DBHawk, admin can add new data file to the tablespace, increase existing size.

Oracle Tablespace Manager

Oracle Datafile Manager

Each tablespace has data files where the data is stored. DBHawk provides Data files monitoring and management. DBA can monitor Data file usage with graph which shows free and used space. It displays Data file location, Auto extensible information, Size, Used size, Percent used size and maximum size. DBAs can view and alter Data files. Using DBHawk, admin can add new data files or alter existing data file.

Oracle Datafile Manager

Oracle Session Manager and Database Monitoring Tool

DBHawk provides advanced Oracle session management. DBHawk provides session details with feature to kill database session, start and stop trace. Session detail includes IO details, Wait, session statistics, current session SQL, session database locks, objects in use for the session. DBAs can automatically refresh session data at regular interval. Also, DBAs can filter session data to view only active session, background sessions etc.
Web-based UI makes Oracle session management very easy and productive for Oracle DBAs to troubleshoot session related issues.

DBHawk also provides Blocking Locks, SGA, Top SQL, Session Wait, Processes, Long Operations, Database Locks, Database Parameters, Active Oracle Jobs, Running Oracle Jobs and V$Views monitoring.

Oracle Session Manager

Oracle User Manager Client

DBHawk provides Oracle database user management. With DBHawk user manager, DBAs can view database user details, view status, Lock/Unlock user, view default tablespace details, view profile and creation and expiration dates. DBHawk provides create new user, alter user. Also, DBHawk provides clone user feature, which makes creating similar user creation very easy.

DBHawk also provides database roles and profile management.

Oracle User Manager Client

Oracle Database Utility Web Client

DBHawk provides various database utilities to help developers complete various tasks. DBHawk provides Enable triggers, Disable Triggers, Enable constraints, Disable Constraints, Run large database scripts utilities.

Online Oracle Database Utility

Oracle SQL Report Builder

DBHawk provides ad-hoc SQL report building capabilities. User can create PDF, Excel, CSV reports.
Learn more

Oracle SQL Report Builder

Oracle SQL Job Scheduler

DBHawk provides SQL Job Scheduling feature. Using DBHawk Job Scheduler, users can schedule reports to receive results by email or save on the disk
Learn more

Oracle SQL Job Scheduler

Oracle Database Query Tool

DBHawk provides advanced database query tool for Oracle.
Learn more

Oracle Database Query Tool

Oracle Schema Compare Tool

DBHawk provides advanced database schema compare tool. It displays schema changes side by side. Users can select various database objects such as Tables, Views, Users etc to compare schema objects with another schema objects. It is helpful for schema comparison between dev, test and production environments

Oracle Schema Compare Tool

Oracle Charts and Dashboards

Using DBHawk, users can create various charts, create dashboards and share created charts/dashboards with other users.
Learn more

Oracle Charts and Dashboards

Oracle Client Tools

FREE TRIAL


top