Saturday, June 17, 2017

handy command line - sqlcl

happen to notice this command line tool called sqlcl from oracle.com

with this , it is portable, no need to administrator to modify sqlnet.ora on windows platform (commonly, in my environment). and not like instantclient, I need to asseble library files and sqlplus.exe into same directory.

Only 3 files after download, for linux, windows platform respectively. but requires JRE.

If no JRE installed, download it , and add %JAVA_HOME%/bin to %PATH% variable (for windows platform)

it supports ezconnect too. This is it.


/cygdrive/d/setup.dsk/apex/sqlcl-4.2.0.17.097.0719-no-jre/sqlcl/bin
$ ./sql.exe liqy/xxxxxx@//dbdev:1582/DB05

SQLcl: Release 4.2.0 Production on Tue Jun 13 13:52:30 2017

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> exit
exit