Free oracle data types software for mac

Navicat Oracle Lite 8.1.2 offers users a useful and user-friendly Database administration tool for Oracle. It works with any Oracle Database Server from version 8i or above, and supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to Oracle.

Benefits:

• Latest Oracle Versions Support: Navicat for Oracle a powerful Oracle Database Server administration and development tool. Highlights of supported features:
• • Support of Oracle versions 8.1.7 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
  • Support of Oracle Objects like Directory, Synonym and Materialized View
• Additional Connection Options
• • 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.
  • Other 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.
• 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.
  • View 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 up to 5 most popular formats including XLS, CSV, TXT, DBF and XML: 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.
• Powerful Data Manipulation Tools
• • 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.
• Powerful Security Management
• • 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.
• Well-Designed Visual Builder / Editor
• • 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.
• 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/Function 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 icon to show and/or modify the properties of Oracle servers.
  • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
  • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.

1. Oracle Objects Management
   • Support Oracle servers 8i or above
   • Create/drop schemas
   • Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions
   • Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
   • Managing tablespaces, public database links and public synonyms
   • Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
   • Support of physical attributes
   • Support of character set and unicode
2. Connection Management and Navigation
   • Multiple local/remote Oracle server connections
   • Support of Basic Connection
   • Support of TNS Connection
   • Connection to Oracle server through SSH
3. Data Viewer and Editor
   • Grid view
   • TEXT, Hex and BLOB/BFile viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Ability to show/hide ROWID
   • Ability to set number of records showing on each page
4. SQL Processing
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Ability to preview SQL before execution
5. Server Security and Maintenance Services
   • Visual user manager to administer users, roles and privileges
   • Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics
     
6. Other Useful Features
   • Empty/truncate tables
   • Backing up schema/table to SQL script
   • Executing SQL script
   • Create table/view shortcut on desktop
   • Support of docking/tab windows
     
   • Ability to run profile from command line
   • Log files: keep track on the actions that have been performed in Navicat
   • Ability to copy Connection Information into Clipboard

• Improvements: Improved the stability when running a query.
• Bug Fixes: Some windows size and position were not saved after closed.

• Mac OS X 10.3 Panther, 10.4 Tiger or 10.5 Leopard
• Universal Binary

Navicat Lite 8.1.2 brings users a full-featured multi-connections Database Administration tool allowing you to connect to MySQL, Oracle and PostgreSQL databases simultaneously within a single application, making database administration to multiple kinds of database so easy.

Navicat Premium combines the functions of other Navicat members. With connections established to different database types, Navicat Premium supports data transfer between MySQL, Oracle and PostgreSQL. It supports most of the features in MySQL, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc.

Navicat Premium enables you to easily and quickly transfer data across various database systems, or to a plain text file with designated SQL format and encoding. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.

Benefits:

• Multi-connections Database Administration tool: Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It combines the functions of other Navicat members and supports most of the features in MySQL, Oracle and PostgreSQL including Stored Procedure, Event, Trigger, Function, View, etc. This is a time saver, and beneficial to any administrator managing multiple servers
  
• • Latest MySQL Versions Support
  • • Support of MySQL versions from 3.21 or above
    • Support all MySQL objects: tables, views, stored procedures/functions and events
    • Support all subobjects: fields, indices, foreign keys and triggers
    • Support of partitioning
    • Support of Unicode / Character Set
  • Latest Oracle Versions Support
  • • Supports Oracle Servers 8.1 or above
    • Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
    • Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
    • Managing directories, tablespaces, public database links and public synonyms
    • Support of physical attributes
  • Latest PostgreSQL Versions Support
  • • Supports PostgreSQL Servers 7.3 or above
    • Support all PostgreSQL objects: tables, views and functions
    • Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
    • Managing tablespace, cast and languages
    • Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
    • Support of character set and Unicode

• Cross-servers Data Manipulation Tools
• • Support of transferring data between servers: 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 data and create records as INSERT statements in SQL file: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their PostgreSQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a PostgreSQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
  • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization from different servers: Profiles from different kind of databases can be created in a single batch job, so that you can set schedule and run at a specific time. Batch job can be created for Report Printing, Backup, Query, Data Transfer, Data Synchronization, Import and Export.
  • Send notification e-mail and attachment 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. Also, exported file or printed report can be added to the batch job as mail attachment so that you can share your data easily.
• Additional Connection Options
• • 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.
  • Support of HTTP Tunnel for MySQL and PostgreSQL Server: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
  • Provide auto-reconnection for MySQL and PostgreSQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
• Comprehensive Management of Database Objects
• • Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer - the basic Navicat Premium tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much 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.
  • View Database / Schema / Table Structure: Present the database / 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 different file formats: XLS, CSV, TXT, DBF and XML: 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: XLS, 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.
• Powerful Data Manipulation Tools
• • 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: Navicat Premium allows you to transfer data from one database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another server.
  • Support of Backup and Restore MySQL/PostgreSQL databases: Regular backup on database is important to users. Backup/restore tables and records, views, functions, etc for your database using Navicat. You can also schedule backups between databases.
• Powerful Security Management
• • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected objects.
• Well-Designed Visual Builder / Editor
• • 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, Function and other database 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.
• More great features
• • Virtual Grouping: Have a better organization over connection and objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature.
  • 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 your servers.
  • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
  • Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
  • 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.
  • Shortcut: Navicat premium allows you to drag and drop tables/views to create shortcuts. This feature can save you a lot of time to access your most used table/view, reducing the number of steps to reach them.

Major Features:

1. MySQL Objects Management
   • Supports MySQL Servers 3.21 or above
   • Create / Drop Databases
   • Support all MySQL objects: tables, views, procedures/functions and events
   • Support all subobjects: fields, indices, foreign keys and triggers
   • Support of partitioning
   • Support of character set and unicode
2. Oracle Objects Management
   • Supports Oracle Servers 8.1 or above
   • Create/drop schemas
   • Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
   • Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
   • Managing directories, tablespaces, public database links and public synonyms
   • Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
     
   • Support of physical attributes
   • Support of character set and unicode
3. PostgreSQL Objects Management
   • Supports PostgreSQL Servers 7.3 or above
   • Create /drop databases and schemas
   • Support all PostgreSQL objects: tables, views and functions
   • Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
   • Managing tablespace
   • Managing cast and languages
   • Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
   • Support of character set and unicode
4. Connection Management and Navigation
   • Multiple local/remote MySQL/Oracle/PostgreSQL server connections
   • Support of Oracle Basic Connection
   • Support of Oracle TNS Connection
   • Connection to MySQL/Oracle/PostgreSQL Server through SSH
   • Connection to MySQL/PostgreSQL Server through HTTP
     
   • Support SSL secure connection for MySQL and PostgreSQL 8.4 above
   • Customize selected MySQL/PostgreSQL databases to work with
5. Data Viewer and Editor
   • Grid view
   • Text, Hex and BLOB viewer/editor
   • Oracle BFile viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Ability to show/hide Oracle table ROWID
   • Support of raw mode edit: apply MySQL/PostgreSQL built-in function
   • Ability to set number of records showing on each page
6. SQL Processing
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Ability to preview SQL before execution
     
   • SQL console
7. Server Security and Maintenance Services
   • Visual user manager to administer users, groups (roles) and privileges
   • Maintance database/schema objects tables
8. Other Useful Features
   • Backing up schema/table to SQL script
   • Executing SQL script
   • Duplicate/empty/ truncate tables
   • Create table/view shortcut on desktop
   • Support of docking/tab windows
   • Ability to run profile from command line
   • Log files: keep track on the actions have been performed in Navicat
   • Ability to copy Connection Information into Clipboard

Enhancements:

• Improvements:
• • Support quitting the Console window by "exit", "quit" or "q" command for MySQL server.
  • Support quitting the Console window by "q" command for PostgreSQL server
  • Improved the stability when running a query.
  • Now owners of objects are not compared or transferred in Structure Synchronization and Data Transfer for PostgreSQL server.
  • Improved an internal SQL which run slowly in PostgreSQL server.
• Bug Fixes:
• • Some windows size and position were not saved after closed.
  • Recalling multi-line history commands in Console were not displayed properly in MySQL and PostgreSQL server.
  • "Copy to Clipboard" did not show host name for MySQL and PostgreSQL server.
  • Dump SQL File did not dump the primary key definition for PostgreSQL server.
  • Could not recognize the host by host name for PostgreSQL server.
  • User defined type fields were not showing the type properly in Table Design (for PostgreSQL server only).

Requirements: Mac OS X 10.4 Tiger or 10.5 Leopard