Free oracle sql developer software for mac

MySQL Database Server 5.1.35 is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. It gives corporate developers, DBAs and ISVs an array of new enterprise features to make more productive developing, deploying, and managing industrial strength applications. If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML or other formats to MySQL.

MySQL Database Server delivers new enterprise features, including: ACID Transactions to build reliable and secure business critical applications. Stored procedures to improve developer productivity. Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata. Distributed transactions (XA) to support complex transactions across multiple databases.

Cache Monitor supports developers with features, like: Advanced SQL Query Editor, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting,Graphical SQL execution plan and more.
You see the process ID (PID) from your connection on the Tabpane on every Query Analyzer. Code completion will let you type a few characters and then display a list of context-sensitive possibilities to complete the text you are typing. Editor code completion brings up a list of Tables or Columns (also known as Intellisense).
Code completion can be triggered by pressing [CTRL+SPACE] or by typing a hotchar or keyword, such as . or , in an SELECT list. Cache-SQL formatting can executed from context menu to make your code, or the code of others, much easier to read (Format SQL). Also supports, of course: Undo/Redo and Search and Replace.
Since version 0.18 the Hyperlink navigation has been added. Hyperlink navigation is a means for simple navigation from the editor to Tables metadata. When you presses the CTRL key and hover the mouse cursor over a certain code element, the element is changed to a hyperlink. When you hold the CTRL key and click on the hyperlink, the go to Tables metadata action is performed.
Since 0.20, Cache Monitor contains features to tune the database.
Main features:
Advanced SQL Query Editor
- Cache-SQL Syntax highlighting
- SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
- SQL History buffer for executed SQL commands
- SQL Code formatting
- Parallel (multi-threaded) queries
- The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
- SQL abbreviations, Type: se to complete to "SELECT * FROM "
- TuneTable for selected Tables or whole Namespaces
- Select2Table Function
DDL Code generation (CREATE TABLE)
MetaData-Browser for
- Namespaces
- Tables
- Views
- Routines
- Classes
- CachedQueries
- Stored Procedures
- Indexes
Cache Monitor can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...).
- Cache Monitor helps you to organize your Server; to classify Cache Servers into groups, divide groups into subgroups etc.
- You can see Cache Version infos from connected Server
- Shows Executionplan from an SQL Statement.
- You can view the selectivity from the used columns in the execution plan
- Shows CachedQueries with their costs and the underlying SQL (AddHoc from Intersystems needed!)
- Select2Table Function
- Fast open Query Analyzer with CTRL+Q on selected Server
- Fast open Query Analyzer with CTRL+O
- CopyTable Function
- Execute TuneTable for selected Tables or the whole Namespace
- Shows PID (ProcessID) from each Query Analyzer connection
- Shows Processlist
- Shows SELECT-Statements from SQL Views
- Show Routines

System requirements:
-

Enhancements
- Global Viewer is now working. Please attention about the global size, currently there is no limit!
- The Table-Viewer have now more filter functions from the context menu (look at the Data Panel and use right click on table).
- Faster startup.

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

Enhancements:

• Qilan is fully compatible with Mac OS X 10.6.
• Qilan has been rebuilt using JNI.
• Webtemplate exports are significantly faster and memory management has been improved.
• There are number of new features including check for Qilan updates, new operators and a find function.