#SQL DEVELOPER COMMAND LINE FOR MAC HOW TO#
#SQL DEVELOPER COMMAND LINE FOR MAC MAC OSX#
#SQL DEVELOPER COMMAND LINE FOR MAC INSTALL#

The above command includes hr as the username, and oracle as the password. If you don’t have SQL Developer in the Applications folder, change the path accordingly. SQLcl can be launched by opening a Terminal window and entering the following: /Applications/SQLDeveloper.app/Contents/resources/sqldeveloper/sqldeveloper/bin/sql hr/oracle SQLcl is a command line interface for working with Oracle databases. Installing SQL Developer also installs a copy of SQLcl. SQL Developer is now installed and connected to Oracle. Once connected, the connection is added to the connection list under Oracle Connections: If it works, the little Status heading (bottom left) will get a Success message next to it. Select the Service Name option, and use orcl as the value. Oracle (also check the Save Password box if you want to save your password). If, like me, you have just installed the Oracle DB Developer VM, the following details should work: NameĪnything you want. That launches the New / Select Database Connection screen.Įnter the details for your connection. Now that SQL Developer is installed and running, you can can use it to connect to Oracle.Ĭlick the green plus sign (or its adjacent down arrow and click New Database Connection.): Here’s what the GUI looks like once it has launched: Connect to Oracle Once it has launched successfully, the GUI appears. Otherwise, if the application launches OK, you may see the following prompt, in which case, click No if you don’t have any preferences to import:

#SQL DEVELOPER COMMAND LINE FOR MAC HOW TO#

If you get a message telling you it can’t be opened, see this article for how to fix it. Launch SQL Developerĭouble click the SQLDeveloper.app file to launch SQL Developer. zip file.ĭrag the SQLDeveloper.app file to the Applications folder (or another folder if you prefer). However, if it was downloaded to your Downloads folder, you might like to move it to your Applications folder or another folder. It can be run as soon as its extracted from the. SQL Developer doesn’t require any special installation process. In my case, this was sqldeveloper-20.4.1. Once downloaded, the file has the same name as the one on the button. When the prompt appears to accept the licence agreement, check the box and click the Download button:

#SQL DEVELOPER COMMAND LINE FOR MAC MAC OSX#

Locate the Mac OSX option and click the Download link next to it: Once that’s finished, you can continue with the steps below. dmg file and follow the installer prompts.

If you don’t have the JDK, you can download it from the Oracle website. If the command doesn’t work, then you probably don’t have the JDK.

If you do have it installed, you should see something like this, depending on the version: javac 1.8.0_291 If you’re not sure whether you have the JDK or not, run the following command in a Terminal window: javac -version SQL Developer requires that you have Oracle JDK 8 or 11.

#SQL DEVELOPER COMMAND LINE FOR MAC INSTALL#

Here’s a quick rundown on the steps I took to install SQL Developer on a Mac. It’s available on many major operating systems, including Window, Linux, and of course, MacOS. SQL Developer is a GUI tool for working with Oracle Database.

Sql developer command line for mac