Oracle SQL developers can use visual SQL 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.
DBHawk supports full online Oracle database browsing capabilities. Users can view database table data, filter data, count a total number of rows in a table.
DBHawk online data editor allows to create, insert, update, and delete data. Users can also update clob, blob data.
DBHawk online export data feature allows exporting table data into CSV, HTML, insert and pdf formats.
Users can also import CSV data directly to the tables. DBHawk parses 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 a regular interval.
Using DBHawk, users can view Oracle table column details, alter table columns, and add new columns.
Table indexes provide an 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 an index.
Users can add Non-unique, Unique and Bitmap indexes using DBHawk index creator.
Constraints are the rules enforced on data columns on the 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. A 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.
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.
With granted privilege, a 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 displays current Object’s granted privileges and allows a user to revoke those privileges with a simple click.
DBHawk displays table references details. Using a 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 depend on objects.
DBHawk display table DDL with a simple click. DBHawk runs DBMS_METADATA.GET_DDL(‘TABLE’,’
‘) to get table DDL.