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].
But wait, where is the Java?
Create even more powerful Mac versions of your iPad apps. Apps built with Mac Catalyst now take on the new look of macOS Big Sur and help you better define the look and behavior of your apps. You can choose to turn off automatic scaling of iPad controls and layout, allowing you to precisely place every pixel on the screen. PL SQL Developer for Mac OS X: Best alternatives Compare PL SQL Developer for Mac with best handpicked alternatives, rate them and add your own ones. MySQLWorkbench Free. By Oracle Corporation. MySQL Workbench is a unified visual application for database architects, developers, and DBAs. MySQL Workbench provides data modeling. Download Sql Developer For Mac Os X Oracle SQL Developer is a free, development environment that simplifies the management of Oracle Database in both traditional and Cloud deployments. It offers development of your PL/SQL applications, query tools, a DBA console, a reports interface, and more. For example, on a Windows system you may want to ensure that the SQL Developer folder and the AppDataSQL Developer folder under Users are not sharable; and on a Linux or Mac OS X system you may want to ensure that the /.sqldeveloper directory is not world-readable.
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!
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.
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… Visual basic code examples for beginners.
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 Developer Mac Os Download Free
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.
- Freeware
- In English
- Scanned
- 3.95
- (9.87 K Downloads)
Looking for a program that makes managing, integrated, and organizing Oracle databases quick and efficient? Well then, look no further as Oracle SQL Developer is the perfect software for you to use? Oracle SQL Developer is a software that helps the user to manage their Oracle databases. Oracle SQL Developer gives the user an easy interface, which helps the user in creating and editing SQL databases with ease. Oracle SQL Developer has an incredibly elegant, intuitive, and easy to use user interface (U.I.) that helps users new to SQL learn quickly, and it helps experienced users do their work quicker. Oracle SQL Developer lets you browse your database objects, and it allows you to edit and debug PL statements. Oracle SQL Developer also allows the user to run SQL statements. Oracle SQL Developer also gives you detailed reports about your database.
System Requirements for running Oracle SQL Developer
- Oracle SQL Developer works on devices running 64-Bit Windows (7 or higher).
- A 2 GHz or faster processor is required for running Oracle SQL Developer smoothly.
- At least 1 GB of RAM is necessary for running Oracle SQL Developer (Although 2 GB of RAM is recommended).
- Around 50 MB of free storage space is required to install Oracle SQL Developer.
- You also need to install JDK before running Oracle SQL Developer.
Main Features of Oracle SQL Developer
- User Interface (U.I.) – Oracle SQL Developer has an intuitive and easy to use user interface (U.I.) that is helpful to both beginners and experts.
- Reports – Oracle SQL Developer creates detailed and extensive reports for the user to see. Oracle SQL Developer also allows the user to create their own reports.
- Oracle SQL Developer has an interesting DDL generation feature.
- Oracle SQL Developer supports both the physical Oracle 12c model and the relational database model, which is extremely helpful and convenient.
- Oracle SQL Developer also bridges the gap between logical and relational models.
How to use Oracle SQL Developer?
After Oracle SQL Developer has been downloaded, click on the app icon to open the app. On the top of the Oracle SQL Developer interface is the toolbar with the File, Edit, View, Navigate, Run, Teams, Tools, Windows, Help tabs. The left side of the Oracle SQL Developer interface has the connections tab, where you can view the different database connections. The central part of the Oracle SQL Developer interface has the working area, and within this are the worksheet and the query builder tabs.
How to get Oracle SQL Developer?
You can get Oracle SQL Developer by following the steps given below –
- 1. Click on the download button to start installing Oracle SQL Developer.
- 2. Download and open the Oracle SQL Developer installer.
- 3. Read the Oracle SQL Developer ToS (Terms of Service) and agree to it.
- 4. Read the Oracle SQL Developer License agreement and click on agree.
- 5. Select the destination folder for Oracle SQL Developer and wait for it to install.
Sql Developer Mac Os Download Windows 10
6. You can now use Oracle SQL Developer anytime you want.
Pros
- Easy to use.
- Intuitive user interface.
- Reports feature.
- DDL generation feature.
App Name: Oracle SQL Developer (64-bit)
License: Freeware
OS: Windows 7 64 / Windows 8 64 / Windows 10 64
Latest Update: 2020-12-09
Developer: Oracle
User Rating: 3.95
Category: Developer Tools
Comments are closed.