Free oracle sql software for mac

Oracle JDeveloper is a powerful software that marks a significant milestone in the progress of application development.

We spent more time than ever in this release listening carefully to what our users need in order to make them more productive. We also embarked on an intensive design and usability review by an external company.

The result of these efforts is a huge leap forward in the speed in which developers can create, assemble, and reuse components to build rich, interactive applications that are highly performant and easy to maintain.


Enhanced use experience

There have been many updates throughout the product to make working with JDeveloper a pleasant experience. These improvements are not restricted to a particular type of development, but have been applied consistently to all areas of the design time.
• Enhanced navigator: The Application Navigator has been enhanced to organize your application the way you want. New categories make it easier for you to find what you are looking for. Collapsible panels put common elements of your application within easy reach. Files that make up a composite node are conveniently exposed by simply clicking on the composite node.
• Improved Component Palette: The component palette now features collapsible panels and divider sections to organize related components. A quick search field is provided to help locate components. You can now add commonly-used components to your Favorites list for easier access later, and another panel keeps track of your recently used components.
• New Property Inspector: The Property Inspector has been redesigned with a new, user-friendly layout. Property categories have been used consistently throughout the product to make using the Property Inspector more predictable.
• Application Overview: The new Application Overview window provides a convenient listing of all the sources for your application, grouped into helpful categories. From here, you can get a sense of the overall status of your application (which sources are incomplete, which have errors, etc) too. The Application Overview also functions as a way for you to learn about the various kinds of components you may use in your application, and easily launch wizards to create them.
• File List: The File List makes it easier than ever to locate source files that are part of your project. You can search by file name, file extension, status, date modified and more.
• Updated appearance: The JDeveloper development environment has been updated with a brand-new look.
• Integrated modeless editors: Many editors for components have been converted to integrated modeless editors. These appear in the editor area along with the other editors, and allow for much more productive navigation.
• Contextual linking: Contextual linking is the concept that as you are working on something, you should be able to easily get to relevant related resources. For example, as you are working on defining a page flow for databound pages, you should be able to easily get to the page definition of those pages. This concept is now employed wherever it makes sense in the development environment.


Resource Catalog

The Resource Catalog is your window onto the many disparate resources your application may need to consume. It allows you to define connections to the resource providers, and drag-and-drop those resources into your application as needed. The resource catalog provides a search tool to search all the defined repositories in a single action.

Connections can be created for the following types of resource repositories:
• Application server
• Database
• File system
• UDDI Registry
• URL adapter
• WebDAV

New diagramming framework

The internal diagramming framework used to build the UML tools in JDeveloper, the Page Flow diagrams, and other visual editors has been re-architected to be more flexible for internal consumers.


Java Coding and Agile Development


New code generators

New generators have been added for generating equals and hashcode and to simplify generating fields and properties with getters and setters and to generate constructor from fields

Updated JUnit 4.0 support

JDeveloper now generates unit tests using JUnit 4 annotations. The integrated runner has been updated to support JUnit 4, including new instructions, such as @ignore.

New profilers

The new profilers leverage JVMTI and therefore run on any certified Java VM. Oracles OJVM is no longer required for profiling.
• CPU Profiler
• Memory Profiler

XML Compare

Comparing of XML files is now done using an XML-aware algorithm. In previous releases compare was done using a line algorithm with no understanding of the syntax of the file content. XML is used extensively within JDeveloper (projects, diagrams, ADF artifacts) and the characteristics of the file content will be understood by the tool.

For example if an XML elements attributes are reordered the compare tool will not mark that as a change - the attributes (name and value) are the same, but in different positions.

The compare tool is used by all the version control extensions to compare file content with previous versions. Compare is also used by the local history feature to compare content between saved points.

Enhanced Merge Conflict Resolution for Subversion and CVS

JDeveloper now provides an enhanced XML-aware interactive GUI to browse and update unresolvable conflicts reported during the merge process.

With Navicat well-designed Graphical User Interface (GUI), Navicat for Oracle lets you quickly and easily create, organize, access and share information in a secure and easy way, taking Oracle administration to the next level.

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

iPhoto To SQL is an export plugin for iPhoto that will create an SQL dump file with all picture metadata in addition to creating scaled images and thumbnails. If youve written your own photo gallery software, use this to get your photos and associated metadata into your database backend.
iPhoto To SQL will create the following fields: id, title, comment, keywords, stars, date, album, thumbnail filename and image filename. You can set height/width maximums on the thumbnails and images and they will be rescaled with their aspect ratio preserved.
Enhancements:
- Minor fix to no longer clobber the SQL file when doing multiple exports.
- The SQL file is named for the album being exported also saved in the directory itself.

Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.

Major Features:

1. Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
   • Support of MySQL versions from 3.21 or above
   • Support of Unicode / Character Set
   • Support of MySQL Events, Views and Stored Procedures creation
   • Support of Triggers
   • Support of Foreign Keys
   • Support of Partition
2. 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: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
   • Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
3. Comprehensive Management of MySQL objects
   • Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL 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 / Table Structure: Present the database / 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 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.
   • Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
5. 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 for MySQL allows you to transfer data from one MySQL 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 MySQL server.
   • Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
   • Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL database using Navicat. You can also schedule backups between databases.
   • Create Schedule for Backup, 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, Backup, Data Transfer, Data Synchronization, Import and Export.
   • Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
6. 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 databases, tables/views, fields and stored procedures/functions.
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.
   • Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event 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.
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, Event, Query, Backup 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 MySQL 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.

Enhancements:

• Improvements:
• • Improved compatibility to some ODBC drivers for Import Wizard.
• Bug Fixes:
• • Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
  • 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.4 Tiger or 10.5 Leopard