Importing data from other file formats : DBF etc.

Importing data from plain text file formats : TXT, CSV, XML etc.

Importing data from ODBC: MSSQL, Oracle etc.

Enhanced find and replace options in SQL editorsĭiversified Import and Export Competence:.

Support code folding, highlighted matches words and brackets.Multiple SQL editors with syntax highlighted feature.Code outline for Oracle functions/procedures/packages/types.Visual query/view builder to facilitate the process of building complicated queries.Ability to set number of records showing on each page.Support of foreign key data selection: locate the available values from the reference table.Support of raw mode edit: apply MySQL/PostgreSQL/SQLite built-in function.Ability to show/hide Oracle and SQLite tables ROWID.Incremental search, sorting and formatting table grid.Ability to set simple and complex breakpoints.Support on showing interactive and real-time debugging information.Customize selected MySQL/PostgreSQL databases to work withįeature Rich Oracle PL/SQL Code Debugger:.Support SSL secure connection for MySQL and PostgreSQL 8.4 above.Connection to MySQL/PostgreSQL/SQLite Server through HTTP.Connection to MySQL/Oracle/PostgreSQL Server through SSH.Support to connect a new or an existing SQLite database.Multiple local/remote server connections.Support all subobjects: triggers and indices.Support all SQLite objects: tables and views.Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.Support all PostgreSQL objects: tables, views and functions.Supports PostgreSQL Servers 7.3 or above.Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.Managing directories, tablespaces, public database links and public synonyms.Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers.Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.Support all subobjects: fields, indices, foreign keys and triggers.Support all MySQL objects: tables, views, procedures/functions and events.

All-In-One Database Tool for MySQL, SQLite, Oracle and PostgreSQL

Navicat full