From the course: Learning Oracle Database 19c

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

SQLcl command-line tool

SQLcl command-line tool - Oracle Database Tutorial

From the course: Learning Oracle Database 19c

Start my 1-month free trial

SQLcl command-line tool

“

- [Instructor] The original SQLcl Plus Command-Line Tool has been around for decades, but now a new Command-Line Tool, Oracle SQLcl, is available and is automatically included with a server side installation of Oracle Database 19C. Of course, you can install just SQLcl on your client machine such as a pc or laptop. I'll give a brief overview of the advantages of SQLcl, its requirements, and the features you can't live without if you don't have access to a GUI environment for SQL developer or you need to script a batch job that SQLcl will run for you in any of your favorite scheduler applications. Here are the requirements for SQLcl. You need to be running Java version 8 or higher, either the Java runtime environment JRE or it will also work if you have the Java developer kit installed JDK. It's trivial to install. Put it anywhere on your local disk drive, and for convenience, you can put the location in your PATH variable, but that's not required. If you have installed Oracle database…

Contents