Oracle Database Query Tool Features

The Oracle database query tool features provided by RazorSQL include a custom Oracle database browser tailored to Oracle, a PL/SQL SQL editor with Oracle and PL/SQL specific features and syntax highlighting, Oracle import and export tools, custom Oracle GUI and visual tools, and Oracle specific database administration tools. Listed below are more details on these features.

Oracle GUI Tools Oracle GUI Tools

Oracle Database Browser Oracle Database Browser

  • Displays information in a tree format for schemas, tables, views, procedures, functions, triggers, packages, package bodies, indexes, constraints, sequences, materialized views, materialized view logs, and clusters.
  • Displays Oracle table information such as column name, column type, column length, column nullability, and primary and foreign key information
  • An Oracle View DDL option for viewing the create table SQL for tables and the DDL for other Oracle objects such as views, indexes, procedures, etc.
  • Easily view table contents or database object information via the View Contents and Show Info context menu options

Oracle SQL Editor  Oracle SQL Editor

Edit SQL and PL/SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.

Oracle Import Tool Oracle Import Tool

Import data from various formats such as delimited files, Excel spreadsheets, and fixed width files.

Oracle Export Tool Oracle Export Tool

Export data in various formats such as delimited files, Excel spreadsheets, text, HTML, XML, and SQL insert statements.

Oracle Table Editor Oracle Table Editor

Edit tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.

Oracle SQL Query Builder Oracle SQL Query Builder

Easily build select, insert, delete, and update SQL queries. Build multi-table joins.

Oracle Database Convertion Tools Oracle Database Conversion Tools

Convert database tables from Oracle to other database types and from other database types to Oracle.

Below is a screen shot of the RazorSQL Oracle GUI Tool

Oracle GUI Tool