Oracle sqlcl setup on MAC M3 Tips

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience, all while also supporting your previously written SQL*Plus scripts. 

Download Java for macOS
Recommended Version 8 Update 441 (filesize: 90.13 MB)
Release date: January 21, 2025

jre-8u441-macosx-aarch64.dmg

echo 'export JAVA_HOME=/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/jdk/' > ~/sqlcl_env
echo 'export PATH=/Users/honglin/sqlcl/bin:$PATH' >> ~/sqlcl_env 

(base) honglin@macos ~ % cat sqlcl_env 
export JAVA_HOME=/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/jdk/
export PATH=/Users/honglin/sqlcl/bin:$PATH
(base) honglin@macos ~ % sql system/Welcome12345#@localhost:1521/freepdb1
zsh: command not found: sql
(base) honglin@macos ~ % source sqlcl_env
(base) honglin@macos ~ % sql system/Welcome12345#@localhost:1521/freepdb1


SQLcl: Release 24.3 Production on Sun Jan 26 15:37:36 2025

Copyright (c) 1982, 2025, Oracle.  All rights reserved.

Last Successful login time: Sun Jan 26 2025 15:37:37 +08:00

Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.6.0.24.10

SQL> show pdbs;

   CON_ID CON_NAME    OPENMODE      RESTRICTED    
_________ ___________ _____________ _____________ 
        3 FREEPDB1    READ WRITE    NO            
SQL> 

Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience, all while also supporting your previously written SQL*Plus scripts.