Oncilla
 Take a tour     Download and Try it now
Buy Download
The New version 1.0.1 is here!

Download the 1.0.1. Try it now free for 90 days. See Release Notes

Main Features

Oncilla Imagine is a powerful Unicode Oracle client and Integrated Development Environment for Oracle® database. Built for power users.
What makes Imagine a cut above the rest? Just look at the following features:

Maximize efficiency

  • Multi-language capable, Unicode Oracle Client. Globalization support with UTF-8 as the standard Oracle client encoding.
  • Multi threaded environment
  • Performance optimizations for Oracle® Application databases.
  • Smart and simple navigation, reducing your learning time.
  • Create and Edit Database Objects like tables, views, synonyms,sequences, functions/procedures, packages, indexes, constraints, objects, collections etc.

Manage your database easily

  • Our database Schema browser makes viewing any object a breeze.
  • Easy Object search to get you what you want.
  • Love using the Internet? Now you have the power and simplicity built in the Schema browser to access database objects using Hot links.
  • Context sensitive menus for existing database objects, generate DML, DDL statements/code in a snap.

Development made easy

  • Create and execute queries and scripts with the SQL editor. A host of smart menu features to make writing queries a snap.
  • Powerful Grid features let you print, export and copy your SQL statement results.
  • Intuitive workspace to see everything you are working on in one place.
  • Embedded worksheet to connect through SQL*Plus.
  • Create and Edit functions, procedures, packages, triggers etc with the PL/SQL editor.
    Also works as a General Purpose Editor with syntax highlighting capabilities for pl/sql, java, jsp and c++.

Advanced tools and Capabilities

  • Import Data: Apply Filters and Transformations to the data being imported. Generate Import scripts and Project files for your conversion routines.
    A must have Data Conversion tool.
  • Compare Files/Directories and generate HTML reports.
  • Code Bank: Access sample code for various operations and constructs from the Code Bank.

Introducing powerful new code generation capabilities

  • Generate PL/SQL Code to execute any Procedure/Function.
  • Generate Anonymous Blocks for Procedures/Functions. A useful debugging tool.
  • Generate Java Wrapper code to call any Procedure/Function (Argument support for most of the Oracle data types).
    Build and deploy Java applications that connect to an Oracle database using JDBC.

Professionally designed to meet windows interface guidelines, Oncilla Imagine users can expect a familiar and intuitive user interface.
Compatible with Microsoft Windows 2000, Windows XP and Windows VISTA

News
» 02 May 2008
Oncilla Technologies announces the release of its product Oncilla Imagine 1.0.1, checkout whats new in this version
(Release Notes).
» 21 April 2008
Oncilla Technologies announces the release of its Beta product Oncilla Imagine 1.0.1, checkout whats new in this version
(Release Notes).
» 10 December 2007
Oncilla Technologies announces the release of its product Oncilla Imagine 1.0.0, designed for Professional and Enterprise use. Completely free for all educational purposes.
» 30 march 2007
Oncilla Technologies announces the release of Maintenance and feature upgrades for Oncilla Imagine, Free Edition.