Download Oracle Sql Developer For Mac Os

One of the great benefits to having an application developed on the Java platform is the ability to run it on many different operating systems. While Windows may still be the corporate standard in more shops than not, geeks worldwide know that Apple’s hardware and OS (OS X) are ‘superior.’ With yesterday’s release of Mountain Lion (10.8) I figured this was a good time to do a quick write-up on how to get started with SQL Developer on your [i]Mac[Book|Mini].

Installing an Oracle database on a Mac computer is a bit different to installing it on a Windows or Linux computer. Oracle doesn’t support running an Oracle database directly on a Mac computer. You can’t install Oracle Express, for example, in the same way that you can on a Windows computer. The good news is that you can use a Virtual Machine. Download the file specific to Mac OS X and double-click to unzip the file. This creates an icon for SQL Developer on your desktop. Double-click to run the application. Use the Linux rpm command to install SQL Developer. For example, your command might look like the following: rpm -Uhv sqldeveloper-4.1.0.19.07-1.noarch.rpm. Download sqldeveloper mac for free. Developer Tools downloads - SQLDeveloper by Oracle and many more programs are available for instant and free download.

But wait, where is the Java?

The Java runtime that had been included with the OS X installs is no longer available in Mountain Lion. As I understand it, even if you had installed your own version of Java, when you upgrade or install 10.8, they will go away.

So if you try to run a previously installed version of SQL Developer, you won’t get very far. Java applications don’t run very well sans Java, tsk, tsk.

So for the n00bs out there (including me), here’s your

Step-By-Step Guide for Installing Java and SQL Developer

Let’s install Java first.

Getting to the download page is your first task. I’ll make it easy for you.

* Yes, I know we officially support 1.6 and not 1.7, but here’s a secret: 1.7 works just fine in version 3.2.20_09 of SQL Developer!

Once it’s downloaded, double-click it.

But wait! Oh no!

Download Oracle Sql Developer For Mac Os

Open your preferences, go to the security panel, and select the unsigned software option

Now, we’re cooking with gas! Try double-clicking the download again.

It should go without a hitch. If it does, you’ll see something like this:

Make sure the ‘right’ java is setup and working.

Download Oracle Sql Developer For Mac Os

Open a terminal, and run

[text]
java -version
[/text]

If you see ANYTHING but the following…

…you may have a problem.

But this is Apple and OS X, and so it will find Java just fine.

Ok, now we can worry about downloading and installing SQL Developer.

Go here and download ‘Oracle SQL Developer for Mac OSX platforms.

Once it’s downloaded, you’ll need to extract it and run it.

Wait a second…

You know it’s going to ‘work’ if you see the splash screen 🙂

But My SQL Developer is Using the Wrong JDK!?

SQL Developer will use whatever Java it can find. If you have the 1.6JDK installed as well, it might find that first. If you want to force it to use the 1.7 you just installed, all you need to do is explore the SQL Developer package, and edit the sqldeveloper-Darwin.conf file in the bin directory.

You may have noticed that Java 1.6 installs to a different directory than 1.7 on OS X.

  • 1.6 – /System/Library/java/JavaVirtualMachines/1.6.0.jdk/Contents/home/
  • 1.7 – /Library/java/javaVirtualMachines/1.7.0.jdk/Contents/Home/

Just update the ‘SetJavaHome’ entry to the version of Java you want SQL Developer to use when it runs.

A Few More Notes

You might be wondering why I installed Java 1.7 when we technically only support 1.6. Well, 1.7 will work, and that’s what many of our developer use internally. If you don’t like bleeding edge, feel free to follow the exact same instructions and grab JDK 6 instead.

This is one of the first work related blogs I’ve written on my home machine a la Mac. I didn’t have my trusted Windows friend SnagIt at hand, but @brentO turned me onto a free and very handy utility called ‘Skitch.’ It works, and once you forget all the normal Windows application ‘way of doing things,’ is also very intuitive. And it’s free, did I mention that? Thanks Brent!

Sql Server Developer Download

If you don’t like that the application title has an underscore in it, e.g. ‘SQL_Developer,’ then here’s a nice post from @martinpaulnash explaining how to fix that too.

84,722 downloadsUpdated: November 15, 2013Freeware

A handy, reliable application that was developed in order to help you enhance productivity and simplify database development tasks

What's new in Oracle SQL Developer 4.0.0.13.30 EA3:

  • Database Performance Monitoring:
  • SQL Developer now provides a full interface for Oracle Database Enterprise Edition’s Diagnostic pack, including Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH). Accessible from the DBA panel, users can also manage their snapshots, baselines, and baseline templates.
  • Find Database Object - Search:
Read the full changelog

Oracle SQL Developer is a free IDE that enables users to easily and effortlessly develop and manage Oracle database.

To install the application you have to download and extract the 181 MB TAR archive and copy Oracle SQL Developer to the /Applications folder.

Oracle SQL Developer is designed to provide complete end-to-end development of PL/SQL apps, a DBA console for database management, a migration platform for easy import of third party databases, a worksheet for running scripts and queries, a reports interface and a comprehensive data modeling solution.

In other words, by using Oracle SQL Developer, you will be able to view and browse database objects, edit and debug PL/SQL statements, and also run SQL scripts and statements.

Moreover, Oracle SQL Developer is capable to connect to any Oracle Database and allows you to migrate from third party databases to Oracle. You also have the option to use third-party plugins in order to connect to non-Oracle databases.

Other useful features provided by Oracle SQL Developer are the code insight, automatic tabs, bracket matching and syntax coloring for PL/SQL.

Thanks to the integration with Oracle APEX, you can also browse, import, export, drop or deploy applications. On top of that, you can create custom reports or use one of the provided Application Express reports.

From Oracle SQL Developer's user-friendly interface you can easily browse and read all files stored in the file system. At the same time, the menu bar offers quick and easy access to all the tools you might need, such as the PL/SQL Unit Testing, Data Modeler, Data Miner and more.

In conclusion, Oracle SQL Developer might be the ideal solution for users who are looking for a free integrated development environment designed to enhance their productivity and ease the database development tasks.

Filed under

Download Oracle Sql Developer 12c

Developer

Download Hubs

Oracle SQL Developer is part of these download collections: Oracle Clients

Oracle SQL Developer was reviewed by George Popescu
4.5/5
SYSTEM REQUIREMENTS
  • Oracle 9.2.0.1 or later.
Load comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policySql

Oracle SQL Developer 3.2.20.09.87 / 4.0.0.13.30 EA3

Oracle Sql Developer Installation Guide

add to watchlistsend us an update

Download Oracle Sql Developer For Mac Os X Platform

runs on:
Mac OS X 10.4.8 or later (PPC & Intel)
file size:
181.7 MB
filename:
sqldeveloper-4.0.0.13.30-macosx.tar.gz
main category:
Developer Tools
developer:
visit homepage

Oracle Sql Developer Download Mac

Download oracle sql developer 12c

Download Oracle Sql Developer For Mac Os X

top alternatives FREE

Download Sql Developer Zip

top alternatives PAID