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.
• Multithreaded 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, Forward and Back buttons.
  
  
  
  
• 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. SQL editor comes with features like Auto Completion, Call tips, Bracket/Parenthesis Matching, Syntax highlighting, Book Mark, Folding, Indentation Guides, WYSIWYG printing and much more.
  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. PL/SQL editor comes with features like Auto Completion, Call tips, Bracket/Parenthesis Matching, Syntax highlighting, Book Mark, Folding, Indentation Guides, WYSIWYG printing and much more.
  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 Conversion tool.
  
  
  
  
• Compare Files 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.