Free what is oracle software for mac

Navicat for Oracle 8.1.5 is considered as a comprehensive GUI tool which lets you create, edit databases, run SQL queries and connect to remote Oracle in an easier way. Also, Navicat provides a number of tools allowing to perform all the necessary database operations such as creating, editing, and duplicating database objects. It also offers a well-described wizard system that simplifies your database development tasks. It supports Oracle 8i and later.

Major Features:

1. 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
2. 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.
3. 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.
4. 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.
5. 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.
6. 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.
7. 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.
8. 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 behavior style. Navicat supports you of dragging windows in and out of the tabbed windows.

Enhancements:

• Improvements:
• • Improved compatibility to some ODBC drivers for Import Wizard.
• Bug Fixes:
• • Data grid was unable to be opened properly when some kind of text were displayed.
  • Removed some internal SQL run by Navicat in Query Viewer.
  • Unable to change the default value of an existing field from NULL to other values in Table Designer.
    

Requirements

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

The Amazing Roach Log Oracle (ARLO) 1.2 is an innovative and versatile log analyzer for Carracho server upload and download logs written in perl. ARLO reads the server logs, and presents various statistical information to the user.

Major Features:

1. General stats for a user (uploads, downloads, leech rating).
2. All of the nicknames a user had when they made file transfers.
3. A list of files uploaded by a particular user.
4. A list of files downloaded by a particular user.
5. The leech ratings of all users on the server sorted by rating or by login name.
6. Server wide stats (uploads, downloads, leech rating, and 4 "top 10" lists.
7. Find a file's uploader(s) or downloader(s) by searching for the filename.

Requirements:

• Mac OS X.

Enhancements: Apr 13 2009

• Added Features
• DB Connect
• Execute Query
• Select Query
• BLOB Support

DataVision is a reporting tool similar to Crystal Reports. Reports can be designed using a drag-and-drop GUI.
They may be run, viewed, and printed from the application or exported as HTML, XML, PDF, Excel, LaTeX2e, DocBook, or tab- or comma-delimited text files. The output files produced by LaTeX2e and DocBook can in turn be used to produce PDF, text, HTML, PostScript, and more.

DataVision is written in Java and runs almost anywhere. It can generate reports from databases or text data files. Any database with an available JDBC driver should work: PostgreSQL, MySQL, Oracle, Informix, Microsoft Access, Progress, hsqldb, and more. Columns read from text files can be separated by any character.

Main features:>
- Drag-and-drop report builder.
- Runs anywhere Java runs: Windows, Linux, Mac OS X, BSD, Solaris, and more.
- Works with any database that has a JDBC driver: Oracle, PostgreSQL, MySQL, Informix, hsqldb, Microsoft Access, DB/2, and more.
- Report headers and footers, page headers and footers, group headers and footers.
- Report field formatting: color, numeric and date format, italic, bold, border lines, etc.
- Editable report-wide default field format.
- Subreports.
- Visual table linker.
- Aggregates (sum, min, max, count, average, stddev) by group and at reports end.
- Record sorting.
- Sub-selects allowed within SQL WHERE clauses.
- Formulas, using any language supported by the Bean Scripting Framework (BSF). The default formula language shipped with DataVision is Ruby (via JRuby).
- Record selection (SQL WHERE clause for database data sources, BSF script that accepts/rejects records for character-separated file data sources).
- Run-time parameters; asks the user for values when the report runs; if running from the command line, reads values in from an XML file.
- Run-time variables (again thanks to the BSF). A script run at the start of each report run is the perfect place to set all your initial values.
- User-defined SELECT clause columns; useful for calling stored procedures or SQL functions.
- Hide columns and entire sections.
- Reports can read data from different data sources. Currently, data sources are defined for databases and text data files (comma-separated, tab-separated, etc.)
- When reading text data files, translates date and numeric columns into the appropriate Java classes so they can be manipulated as such (formatted, used in formulas, etc.)
- Run and view reports on-screen.
- Print report from DataVision.
- Exports to HTML, XML, PDF, comma-separated, tab-separated, DocBook, LaTeX.
- GUI translated into eleven languages.
- Report definitions stored as human-readable XML.
- Open source, so you get all the code to play with and use.
- DataVision is embeddable within your own application.
- The download contains the Java source code, a jar file (so you dont have to compile anything), scripts for running DataVision, examples, and the documentation.

System requirements:
-

Enhancements:
- Removed rc2 VERSION_SUFFIX, ready for 1.2.0 release.
- Updated get-java-installer.sh script for JRE 6 Update 7.
- Updated datavision.nsi file to use Java JRE 6 Update 7.
- Allow end user to decline JRE install in Windows Installer.
- Added README-packaging.txt with developer notes.
- NSIS uninstaller now works.
- get-java-installer.sh only gets file when necessary.
- Added NSIS config files for (experimental) Windows .exe installer.

DbVisualizer 6.5.9 will make you satisfied because it is designed as a feature rich, intuitive and cross platform database tool for developers and DBA's providing a single powerful interface for a variety of databases.

DbVisualizer supports simultaneous database connections, it lets you explore and manage database objects, execute SQL queries, visualize information and a lot more.

Major Features:

1. Database Browser
   • Tree based navigation through all database objects. Browse object details and invoke management features
2. Database Object Management
   • Visual support to create, alter and modify characteristics for database objects such as tables. Edit and compile support for procedures, functions, packages and triggers. Extensive database specific support.
3. Table Data Management
   • Support for editing table data including binary/BLOB and CLOB data types, import from file
4. SQL Tools
   • SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, export large result sets
5. Database Server Management
   • DBA features for managing database instance, storage and security parameters in the database server
6. Tools
   • Export objects in a database/schema as DDL and table data
7. Comprehensive Database & OS Support
   • Oracle, Sybase, SQL Server, PostgreSQL, DB2, Mimer, Neoview, MySQL, Informix, JavaDB/Derby
   • Windows, Mac OS X, Linux/UNI.

Enhancements:

• Bug: DB Support: PostgreSQL The "Databases" object in the objects tree is empty.