From the course: Oracle Database 19c: Basic SQL

Unlock the full course today

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

SQL*Plus

SQL*Plus

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

SQL*Plus

“

- If you've used any Oracle database in the past it's almost certain you've used SQL*Plus at least once. I'll go over the basics of SQL*Plus, how to invoke it, how to tell what commands are specific to SQL*Plus and how to get out. SQL*Plus has been around since the first version of Oracle was released but it was called UFI, User-Friendly Interface, until version 5. Regardless of OS platform if you have Oracle database installed the command "sqlplus" will be in the OS path usually under $ORACLE_HOME/bin. To start up you can just type "sqlplus". On Linux you can find out where executables run by looking at the path variable. In this example you'll see that in a default installation of Oracle database 19c all the Oracle executables reside in /u01/app/oracle/dbhome19/bin. You can run SQL*Plus without any parameters but as you can also see here you're not going to get very far without some kind of log in credentials. The question you might be asking is, "What's so plus about SQL*Plus?" It…

Contents