Soft82.com » Windows » Developer Tools » Database » Database Applications » Navicat Lite for Oracle 8.2.19

View screenshots

Navicat Lite for Oracle Description

Navicat for Oracle - a powerful Oracle Database Server administration and development tool

Navicat for Oracle - a powerful Oracle Database Server administration and development tool. Highlights of supported features:

- Support of Oracle versions from 8i or above
- Support of Multiple Connections to local or remote Oracle Server
- Support of Unicode / Character Set
- Support of Triggers and Foreign Keys
- Support of Views and Stored Procedures creation

Native Connection Options
Navicat for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode and alias entry from a tnsnames.ora file in TNS mode.

Advanced Connection Options
You can set the role for user to connect with Default, SYSOPER or SYSDBA system privilege. Besides, you can pass control of user authentication to the operating system by means of OS authentication option.

Support of SSH Tunnel
Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.

Export Registry Record(.reg) via Navicat for Oracle
You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export a registry file via Navicat and restore it on the new machine.

Comprehensive Management of Oracle objects

Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, triggers and privileges
With Table Designer - the basic Navicat for Oracle tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.

Support of tablespace, package, sequence, synonym, trigger, type and more
Navicat allows you to create, edit and drop directories, tablespaces, publice database links, public synonyms, database links, indexes, materialized views, materialized view logs, packages, sequences, synonyms, triggesr and more.

SQL Preview
The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.

Dump object definition as sql file
Backup object definition and data with ease by dumping as sql file.

Print Schema / Table Structure
Present the schema / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.

Diversified Import and Export Competence

Import data from ODBC
You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.

Import data from up to 11 most popular formats including MS Access, MS Excel, XML, HTML, TXT and CVS
Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.

Export Data to different file formats: TXT, CSV, DBF and XML
Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Form View
Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.

Support of Foreign Key Data Selection
With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!

Data and Structure Synchronization
You can transfer data from one Oracle schema to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target schema can be on the same server as the source or on another server.

Support of Data Transfer between local / remote Oracle schemas
Transfer tables/views/stored procedures/functions/sequences from one Oracle schema to another, or to a plain text file.

Create Schedule for Import / Export, Data Transfer, Saved Queries and Data Synchronization
Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export.

Send notification e-mail for schedule task
Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.

Visual User Manager
Navicat provides users a visual tool for user management. You can easily add, delete, edit users / roles, and grant privileges on the selected schemas, tables/views, fields and stored procedures.

Visual Query / View Builder
Visual Query / View Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.

Query Editor
It allows you to create and edit SQL text for a query, prepare and execute selected queries.

Support of Parameter Query
Set query parameters to add variable values to a query each time you run it.

Code-Completion for Query, View, Stored Procedure and oracle objects
Experience a quick way in constructing SQL statements in SQL Editor with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.


Easy-to-use Report Builder
Create reports with visual Report Builder
Create different types of reports with our user-friendly GUI Report Builder. Design reports for Invoice, Statistics, Mailing Labels and more.
Export report to multiple formats, PDF, Excel, HTML etc.
Enjoy more output formats for report export - text, pdf, Lotus, Excel, Graphic, Html and more. Check out the feature in Report Builder included in Navicat Enterprise Version.
Backup your report as archive file (.raf)
Navicat allows you to backup your reports as an archive file (.raf) to increase portability. This file only stores data at the time you backup.

More great features:

Virtual Grouping
Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Query, Report and Schedule.

Server Monitor
Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and/or modify the properties of Oracle servers.
SQL*Plus
To use a command-line interface, you can open SQL*Plus in Navicat. It provides you an interactive text-based screen to query input and result output from database.

Docking
You can customize your window behaviour style into Docking Windows or Floating Windows. Choose either dock the opened windows to the main window/dock windows or inherit the last docking style.

Profile System
For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Import / Export etc.

Navicat Lite for Oracle Download Button For Your Site

If you want to place a Download Button for Navicat Lite for Oracle on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Navicat Lite for Oracle User Reviews

New Database Applications Software

MyDbExplorer Team Edition May 23, 2012 Connect to virtually any relational database backend				SQL Client May 23, 2012 Connect to your database with this tool
Nevron SSRS Vision May 22, 2012 Professional Data Visualization Component Suite for SSRS				DbWrench May 18, 2012 Our goal with DbWrench is to make database design cycles quicker and easier
Sfairadora May 17, 2012 Flexible tool for small databases with functions of spreadsheet and text output				Reportizer May 17, 2012 Database reporting tool
dbForge Schema Compare for Oracle May 16, 2012 Compare and synchronize Oracle databases with ease				DTM DB Stress Professional May 16, 2012 A utility for stress testing the server parts of information systems and applications
LinqConnect May 16, 2012 A fast and easy to use ORM solution				SQL Vehicle Database Download + ASP.Net May 16, 2012 Get the 1904-2013 vehicle data in MSSQL and MySQL formats
Association Manager May 15, 2012 ALL-IN-ONE, Easy to Use and Membership and Event Management Solution for Associations				DataCleaner May 14, 2012 An Open Source application for analyzing, profiling, transforming and cleansing data
SQL 2 Excel May 14, 2012 Import SQL queries in Excel tables				dbForge Schema Compare for MySQL May 14, 2012 Tool to compare and synchronize structures of MySQL databases
Database .NET May 14, 2012 A simple, uniform and intuitive database management tool for multiple databases				ERD Concepts May 14, 2012 Database software for professionals
dbForge Data Studio for SQL Server May 14, 2012 Chief query tool for SQL Server data analysts and developers				ETL-Tools QlikView Connector May 10, 2012 An ideal tool for customers who are working with complex and bad quality data
Log Table Viewer May 10, 2012 Provides a unified logging interface for your SQL code				DbVisualizer Personal May 10, 2012 Helps you with both the development and maintenance of your databases

Last 7 Days Most Downloaded Database Applications Products

DB Load Generator 37 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 19 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 17 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 16 downloads Firebird is a relational database offering many ANSI SQL-92 features
DbVisualizer Personal 14 downloads Helps you with both the development and maintenance of your databases				NGen NHibernate Code Generator 12 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
EMS SQL Manager for MySQL 12 downloads State-of-the-art GUI tool for MySQL Server administration and development				SQLite3 9 downloads A command-line access program for SQLite databases
Pdxrbld 8 downloads Utility for checking and repairing Paradox tables				MySQL Automatic Backup & Restore Software 8 downloads Backup entire MySQL databases

All Time Most Downloaded Database Applications Products

DB Load Generator 3,350 downloads The easy way to test your database setup, server performance or sql query effectiveness				TOra 802 downloads Database management GUI that supports accessing most of the common database platforms
SQLDumper 6,389 downloads SQL Server Dumper enables you to dump selected SQL Server database tables into SQL INSERT				Firebird 3,331 downloads Firebird is a relational database offering many ANSI SQL-92 features
DbVisualizer Personal 1,075 downloads Helps you with both the development and maintenance of your databases				NGen NHibernate Code Generator 492 downloads A Mapping generator for NHibernate via FluentNHibernate and NHibernate.Burrows
EMS SQL Manager for MySQL 2,066 downloads State-of-the-art GUI tool for MySQL Server administration and development				SQLite3 256 downloads A command-line access program for SQLite databases
Pdxrbld 128 downloads Utility for checking and repairing Paradox tables				MySQL Automatic Backup & Restore Software 312 downloads Backup entire MySQL databases