Free sql manager for 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

Requirements:
Mac OS X 10.0 or later.

Panel Manager is an application to manage and install replacement boot and login panels, i.e. the Mac OS X graphics you see during the boot process and on the login screen.
Panels are the background images that say "Welcome to Mac OS X" by default. You can find many replacement panels at ResExcellence.
Completly freeware.
Enhancements:
- added ability to import all supported panel types at once from themes (.tpkg)
- moved all text into resource file to allow for localization.

List Manager is a sample script made with Dialog Director scripting addition to deal with simple text files that have short records with single lines in them.

Put your files in the Lists folder, and enjoy! Feel free to change the script to match your own needs.

Requirements:
Control Strip Module

Doc Size Manager is a MultiAd Creator AppleScript that lets you save and load your document sizes, and when loading you can choose to keep or replace the existing document sizes.

Completly freeware.