Once open, add the following on its own line: export PATH="/Applications/sqlcl/bin:$PATH" If you don’t have VS Code, try the following instead: vi ~/.zshrcĪlternatively, use an editor of your choice. If it doesn’t already exist, it will be created.
#How to export sql on mac code
This uses my Visual Studio Code application to open the file called zshrc in my home directory. In this case, you can add to your PATH variable like this: code ~/.zshrc Most modern Macs use ZSH when you open the Terminal. This part is optional, but it will make it much easier to launch SQLcl.
#How to export sql on mac full
However, if you plan on using SQLcl a lot, you will probably want to add it to the PATH variable, so that you can launch it without needing to include the full path. You can now start using SQLcl by typing SQL statements and other commands at the prompt. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Last Successful login time: Sun 11:22:21 +10:00 If it connects successfully, you should see something like this: SQLcl: Release 21.2 Production on Sun Jul 11 11:22:20 2021Ĭopyright (c) 1982, 2021, Oracle. Those credentials were created when I installed Oracle on my Mac using the Oracle DB Developer VM. In this case, /Applications/sqlcl/bin/sql is the full path, hr is the username, and oracle is the password.
![how to export sql on mac how to export sql on mac](https://i0.wp.com/freegistutorial.com/wp-content/uploads/2018/08/pexels-photo-1029757.jpeg)
Once you’ve done that, you can launch SQLcl by opening a Terminal window and entering the full path, followed by the default username and password: /Applications/sqlcl/bin/sql hr/oracle For example, you could move it to your Applications folder. If the sqlcl folder is in your Downloads folder, feel free to move it to another location. This extracts a folder called sqlcl that contains various other folders and files. Download SQLclįirst, download SQLcl from the Oracle Website.
![how to export sql on mac how to export sql on mac](https://i.stack.imgur.com/oIu18.png)
If not, you can download the JRE from the Java website. If your Java version starts with 1.8, you’re good to go. Java HotSpot(TM) 64-Bit Server VM (build 25.291-b10, mixed mode) Java(TM) SE Runtime Environment (build 1.8.0_291-b10) In my case, it returns the following: java version "1.8.0_291" If you’re not sure whether you have it or what version it is, open a Terminal window and run the following command: java -version SQLcl requires that you have at least Java Runtime Engine (JRE) 8. You might also want to add its folder to your PATH variable (see the “Add to Path” heading below). However, the version may be different – you’ll need to check the version against the latest available.
![how to export sql on mac how to export sql on mac](https://studio3t.com/wp-content/uploads/2020/02/export-wizard-sql-format-1024x668.png)
In that case, you can run SQLcl as soon as you’ve installed SQL Developer. SQL Developer comes with a copy of SQLcl.
#How to export sql on mac install
Note: If you also plan on installing SQL Developer, then you won’t need to install SQLcl separately. Here’s a quick rundown on the steps I used to install SQLcl on a Mac. It’s available on many major operating systems, including MacOS. SQLcl is a command line tool for working with Oracle Database.